how do i use between instead of greater than or less than , in if then else
statement

To test A1 againts range 100,200:

=IF(AND(A1<=100,A1<=200),"In range","out range")

There is no "between" operator.

HTH
--
AP

"aries" a écrit dans le message de news:
...
how do i use between instead of greater than or less than , in if then
else
statement

"aries" wrote in message
...
how do i use between instead of greater than or less than , in if then
else
statement

If you're looking for A1 to be between B1 and C1, try
=IF(AND(A1B1,A1<C1),D1,E1)
--
David Biddulph

aries wrote...
how do i use between instead of greater than or less than , in if then else
statement

Excel lacks SQL's BETWEEN operator, but if you really can't use < or
for whatever reason, you could try something like

="x "&IF(MEDIAN(x,a,b)=x,"","not ")&"between a and b"

Perhaps ....

=IF(AND(A1=100,A1<=200),"In range","out range")


"Ardus Petus" wrote:

To test A1 againts range 100,200:

=IF(AND(A1<=100,A1<=200),"In range","out range")

There is no "between" operator.

HTH
--
AP

"aries" a écrit dans le message de news:
...
how do i use between instead of greater than or less than , in if then
else
statement

Interesting. I modified it slightly so I could test it and it performed as
expected:

=C4&IF(MEDIAN(C4,A4,B4)=C4,""," not ")&" between " & A4 & " and " & B4

You learn something new every day (or in my case, every other day.)
--
Kevin Vaughn


"Harlan Grove" wrote:

aries wrote...
how do i use between instead of greater than or less than , in if then else
statement

Excel lacks SQL's BETWEEN operator, but if you really can't use < or
for whatever reason, you could try something like

="x "&IF(MEDIAN(x,a,b)=x,"","not ")&"between a and b"