Very Hard formula

[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

 

[Aladin Akyurek]

=(B20>=2%)*(B20<=3.99%)*B25*D25

Custom format the formula cell (D24) as:

[=0]"N/A";General

 

[JE McGimpsey]

one way:

D24: =IF(AND(B20>2%,B20<4%),B25*D15,NA())

 

[Frank Kabel]

Hi bob
sound familiar with another question you posted
Try
=IF(AND(B20>=0.02,B20<=0.0399),B25*D15,"N/A")