how do an @if formula to meet criteria where x is divisible by 12

L

lax_fan

Trying to compound interest earned every 12 months, so setting up an @if
formula based on month equally divisible by 12.
 
J

JE McGimpsey

One way:

Take a look at the FV function

=FV(i/12, n*12, pmt, PV)

where i = the annual interest rate, and n = the number of years. PV =
the present value of the investment/loan, and pmt is any periodic
payment (or 0, if none).

Note: if pmt = 0, FV and PV will be of opposite signs. Think of negative
numbers as outflows of cash, and positive numbers as inflows.

You could also use (assuming pmt = 0)

=PV*(1+i/12)^(n*12)
 
Top