Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Adding the sum of figures in one column if they meet 2 criteria | Excel Worksheet Functions | |||
Countif formula with multiple criteria ie >30 and <60? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |