| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use FV function
Try
=FV(B7/12,B8*12,-B6) -- Regards, Peo Sjoblom (No private emails please) wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use FV function
thank you
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date & Time | New Users to Excel | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
Hybrid Mode
