| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Trouble with condition nested formula
I am trying to nest two formulas based on the result of another cell: the
formula must do one of two functions based result on the lookup cell. A12: is either "A" or "I" B1 $100,000 B2 8% B3 360 formula as written: =IF( a12="a", (pmt(B2/12,B3,B1)*-1,(B1*B2)/12)) the first argument work fine, howver when I enter the second formula (b1*b2)/12, it does not work... CAN ANYONE HELP??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with a Multiply Dependent One Cell Formula | Excel Worksheet Functions | |||
| Hyperlink in nested formula not linking | Excel Discussion (Misc queries) | |||
| trouble with seeing formula in formula bar | Excel Worksheet Functions | |||
| Trouble with nested IF formula | Excel Worksheet Functions | |||
| Add condition to formula | Excel Worksheet Functions | |||
Threaded Mode
