View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How to use FV function

Hi I'm trying to figure out how to use the FV function to come up with
a future value in Excel.

The data from excel is listed like this:
---------------------------------------------------------------------------------------------------------------------------
Investment Plan Analysis

Monthly Deposit Interest Rate Years Future Value
900 5.00% 15
---------------------------------------------------------------------------------------------------------------------------
900 is in cell B6, 5.00% is in cell B7, 15 is in B8, the cell that is
supposed to have the FV function in it is in cell B9 directly below
where it says "Future Value". What value do I put in first, second,
third, etc. using the function boxes...to come up with the Future
Value?

Thanks very much in advanced for any responses.

MC