Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
My form calculates a payment after adding all of the fields that affect the
total financed amount. Two of the fields that are added to the total financed amount calculates the credit life and disability premium respectively. If the credit life and/or the disability Insurance is not selected they return a blank field. As long as both Life and disability are both selected the payment calculates fine. But if either one is not selected and therefore "blank" then the payment = "blank". See the formula below. How can I correct this problem? Thanks. =IF(ISERROR(PMT(AX7/12,BA6,AX4+CE22*CB8+CD14+CC19+CE22+CE26+CE29,,0)), "",-PMT(AX7/12,BA6,AX4+CE22*CB8+CD14+CC19+CE22+CE26+CE29,,0)) CE26 and CE29 contain the formulas that are causing the problem. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem with Array Formula | Excel Worksheet Functions | |||
In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
Excel 2003 Slowness problem in Windows XP | Excel Discussion (Misc queries) | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |