Make sure that (Year cell-year cell) in your formula is actually giving you
the correct total number of payments.
--
Gary's Student
"050529" wrote:
The formul =FV((rate cell),(Year cell - year cell),(amount cell +amount
cell)) is giving me result "num". The objective is to apply a constant
inflationery rate to amounts to arrive at future amount.
--
050529
Accountant
|