formula question (HELP)

  • Thread starter Thread starter Ant
  • Start date Start date
A

Ant

I have a formula question that has 3 if statement.

I'm working in cell D24

And cell B20 is 2%

First, If B20>= B26, I want it to say N/A

Second, If B20<= .0199, I want it to say N/A

Third, If B20 is in between 2% and .0399% multiply B25
to D15
 
Hi
not sure if your conditions are clear without ambiguity but you may try
the following in D24
=IF(B20>=B26,"N/A",IF(B20<=0.0199,"N/A",IF(AND(B20<0.02,B20>0.000399),B
25*D15,"dont know what to do")))
or use
=IF(OR(B20>=B26,B20<=0.0199),"N/A",IF(AND(B20<0.02,B20>0.000399),B25*D1
5,"dont know what to do"))
 
Back
Top