GCD stands for Greatest Common Divisor. It is also called HCF (Highest Common Factor). In simple words, it is the greatest number that can divide a particular set of numbers. For example, the Greatest ...

To calculate the Consumer Price Index between two years in Excel, take a sum of all the amounts spent on the basket of products over those two years. Then use the following formula to find the CPI ...

If you are using Microsoft Excel to manage numerical data, at some point you're inevitably going to display percentages. Doing so can give you a new insight, or make summarizing heaps of data a bit ...

When you enter a number into an Excel cell that looks like a date, such as "Jun-1" or "6/1," Excel automatically adjusts the format of the cell to display a date, so you may not know that Excel ...

Microsoft Excel's spreadsheet design allows you to quickly calculate values separated into two columns and replicate this calculation without having to manually recreate the formula for each row. As ...

In this article we will take a quick look at simple formulas in Excel, especially the calculation of VAT and inclusive of the sale price (including tax) for a purchase price without VAT (tax). Method ...

Investopedia contributors come from a range of backgrounds, and over 25 years there have been thousands of expert writers and editors who have contributed. Charlene Rhinehart is a CPA , CFE, chair of ...

Suzanne is a content marketer, writer, and fact-checker. She holds a Bachelor of Science in Finance degree from Bridgewater State University and helps develop content strategies. Learn about our ...

One of the many variables lenders use when deciding whether or not to loan you money is your debt-to-income ratio or DTI. Your DTI reveals how much debt you owe compared to the income you earn. Higher ...