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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Thanks. I really did not post question correctly, so have done a new one.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How get true response when numbers divisible by 12? 2
Calculating Social Security 3
12 month total in Excel - by worksheet - need a formula 1
IF Formulas 2
How to determine if year is a leap year 7
Calculate interest & withdrawals 0
VLOOKUP to ignore lines which do not meet criteria 1
need help on a formula 2

Back
Top