formula question (HELP)

[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

 

[Frank Kabel]

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