if, and, or "or" statement

M

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?
 
J

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
 
Top