Excel will calculate the number of days between the dates entered in cells B3 and A3 and display the result in cell C3. Take your mouse pointer to the lower-right corner of cell C3.

NPER: Total number of time. PMT: Total amount. PV: Current value of Preset Value. FV: The Future Value. Read next: Calculate Weight to Height ratio and BMI in Excel using this BMI calculation formula.

Just replace the number 50 with the cell number where the figure is located. Image used with permission by copyright holder For more on Excel's other functions, check out our guides on how to use ...

Create a column that lists the number of days for which you want to calculate future values. For example, to calculate the value after 10, 20 and 30 days, enter those values in your vertical ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

For example, Convert 1.5 into percentage. Solution: 1.5 x 100 = 150%. OR (15/ 10) x 100 = 150%. Percentage Difference Formula. To find the percentage difference between two numbers, ...