Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am wanting a formula to calculate mortgage insurance.
If the equity is greater than or equal to 20% the answer should be 0. If the equity is less than 20% but greater than 15% the answer should be a formula that looks like this (equity*0.0036/12). This continues up to 0% equity and the formula below is what I have so far. It gives me the right answer when the equity is greater than or equal to 20% but just says "false" when the equity is between 15% and 20%. I am guessing my problem is with this part of the formula (0.15<=B6<0.2) =IF(B6=0.2,"0",IF(0.15<=B6<0.2,B7*0.0036/12)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement nightmare | Excel Discussion (Misc queries) | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
7+ nested if statement? | Excel Worksheet Functions |