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

Jim Thomlinson


"jai" wrote:

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