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

[Guest]

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]

=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.