Describe

J

jai

I want to write a formula in which I want write that if any cell say A1=
between 4 to 20 and 24 to 30 then display "H" otherwise "Y". How should I
write.
Any shortcut would be grately obliged.

Thanks

Jai
 
J

JE McGimpsey

One way:

=IF(OR(AND(A1>=4,A1<=20),AND(A1>=24,A1<=30)),"H","Y")

I assumed that by "between" you mean to include the endpoints of the
range. Otherwise, use > rather than >= and < rather than <=.
 
P

Peo Sjoblom

One possible way

=IF(A1="","",IF(AND(A1>=4,A1<=20),"H",IF(AND(A1>=24,A1<=30),"H","Y")))



--


Regards,


Peo Sjoblom
 
B

Bernard Liengme

A1 cannot lie between (A and B) AND between (J and K);
It must lie between one pair of number OR the other
If you do not state your problem correctly in English then you have no
chance of getting Excel to solve it.

=IF(OR(AND(A1>=4,A1<=20),AND(A1>=24,A1<=30)),"H","Y")
Please tell me what mark I get for your homework!
best wishes
 
Top