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

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

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)



In article ,
"lax_fan" wrote:

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

Thanks. I really did not post question correctly, so have done a new one.

"JE McGimpsey" wrote:

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)



In article ,
"lax_fan" wrote:

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