Very Hard formula

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

I have a formula question that has 3 if statement.

I'm working in cell D24

And cell B20 is 2%

First, If B20 is in between 2% and 3.99 %, multiply B25
and D15

However if B20 is below 2% or above 4% let it say N/A
 
=(B20>=2%)*(B20<=3.99%)*B25*D25

Custom format the formula cell (D24) as:

[=0]"N/A";General
 
Hi bob
sound familiar with another question you posted :-)
Try
=IF(AND(B20>=0.02,B20<=0.0399),B25*D15,"N/A")
 
Back
Top