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

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

=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

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

=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

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