Why does the following formula not work: =IF(2<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.

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

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



beava37 wrote:

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.

--

Dave Peterson