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

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"jai" wrote in message
...
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