=IF(OR(AND(A14,A1<20),AND(A124,A1<30)),"H","Y")

Vaya con Dios,
Chuck, CABGx3



"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