How to add a range ><

[mazda390]

I like to add if D3>118 but <127,"OK","NO"

The range is between 118 and 127 for it to give me yes/no.


=IF(B3="","",IF(D3>118,"OK","NO"))

[alansidman]

try this:

=if(and(D3>118,D3<127),"OK","NO")

[shg]

=if(b3="","",if(and(d3>118, d3<127), "ok", "no"))

[mazda390]

Once again you guys ROCk.....WORKs like a charm....Thanks for the help, fantastic....