One possible way

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



--


Regards,


Peo Sjoblom



"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