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 <=.


In article ,
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