View Single Post
  #1   Report Post  
Mortgage Man
 
Posts: n/a
Default IF statement with logical_value that is similar to this 0

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))