| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Basic Future Value Formula & Interest Rate Formula
PS....
I wrote: =fv(a1, a2, 0, -a3) where A1 is the annual interest rate, A2 is the number of years, and A3 is the present value. I should have said "present value as a positive number". Often, the PV is represented as a negative number. In that case, you want "a3", not "-a3" above. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| financial function ..please | Excel Worksheet Functions | |||
| interest rate mathematical formula | Excel Discussion (Misc queries) | |||
| Financial formula to calculate interest income | Excel Discussion (Misc queries) | |||
| Formula to calculate cumulative interest | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Threaded Mode
