| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Principle and interest formula - Help
Hi,
Can some one help me with the following. I have had this formula working in a spredsheet for a while now and have realsied it has a limitation. =IF(AND(I23="IO",L23<"",N23<""),L23*N23,IF(AND(I 23="PI",L23<""),PMT(0.09,30,-L23),"")) As you can see the Principle & Interest is worked out at a static 9%. Can someone show me the alteration within this formula (everything else in the formula is working perfectly) required for the P&I part of the formula to read the interest rate placed in N23 (as the formula does for the interest only formula). ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Interest Paid w/ Additional Payments to Principle | Excel Worksheet Functions | |||
| length principle of a number within a cell | Excel Discussion (Misc queries) | |||
| simple average formula...can you solve it in principle? | Excel Discussion (Misc queries) | |||
| reverse principle calculation | Excel Worksheet Functions | |||
| to compute interest rate from principal and interest amount | Excel Discussion (Misc queries) | |||
Threaded Mode
