if, and, or "or" statement

[matmich]

I have a number in A1 and in A2 I need to display a Y if a1 is greate
than 84 and less than or equal to 108. Its simple I know but I am no
getting it. What formula would I use?

 

[JulieD]

Hi

=IF(AND(A1>84,A1<=108),"Y","N")

that's if you want a "N" if it isn't, otherwise, just omit the N

Cheers
JulieD

 

[Jeff]

Sometimes its the simple ones that drive us nuts

=if(or(a1>84,a1<=108),"Y","N")

 

[Leo Heuser]

=IF(AND(A1>84,A1<=108);"Y","N")

is a safer bet