IF Function Question

[LindaDuhe]

I have a column with numbers in it. Each of these numbers I want to logically test to the following statement:
IF > 21 AND < 180 THEN YES otherwise NO for example. So in other words I want to know if the number in my column is between 21 and 180. I know I have to use an IF statement but I do not know how to combine the 2 conditions into one formula.

Can anyone help? Thanks in advance!

 

[Gerald Higgins]

=if(and(a1>21,a1<180),"YES","NO")

 

[Joe4]

Use IF and AND. Let's say you are testing the value in cell A1, then use:

=IF(AND(A1>21,A1<180),"Yes","No")

 

[DiscoPistol]

=IF(AND(A1>21,A1<180),"Yes","No")

DP

 

[DiscoPistol]

I need to learn to type faster........

 

[barry houdini]

You could also return TRUE or FALSE with the shorter

=(A1>21)*(A1<180)