Why does the following formula not work: =IF(2<A1<=2.25,2.25," ")

B

beava37

I typed this in, where the reference A1 was equal to 2.1. The result should
be 2.25, but for some reason it gives me the " " was a result. Please let me
know how I can correct my formula to get the correct result.
 
D

Dave Peterson

=if(and(2<a1,a1<=2.25),2.25,"")


I typed this in, where the reference A1 was equal to 2.1. The result should
be 2.25, but for some reason it gives me the " " was a result. Please let me
know how I can correct my formula to get the correct result.
Click to expand...
 
Top