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 <B0AF2243-3FC2-4DB8-987E-(E-Mail Removed)>,
jai <(E-Mail Removed)> 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>=24,A1<=30),"H","Y")))



--


Regards,


Peo Sjoblom



"jai" <(E-Mail Removed)> wrote in message
news:B0AF2243-3FC2-4DB8-987E-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
news:B0AF2243-3FC2-4DB8-987E-(E-Mail Removed)...
>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")

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