An Excel sheet containing values in column A, and the LEN function in cell B1. An Excel sheet containing the LEN calculation beyond the required cells. The LEN function with TRIMRANGE in Excel.

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

However, while online calculators might be useful, it is prudent to verify their results. By using the Excel FV function, you can ascertain the future value of an investment.

This Technology Workshop illustrates how to leverage a number of functions to perform calculations in Excel involving the time value of money.