G Guest Jun 15, 2006 #1 how do i use between instead of greater than or less than , in if then else statement
A Ardus Petus Jun 15, 2006 #2 To test A1 againts range 100,200: =IF(AND(A1<=100,A1<=200),"In range","out range") There is no "between" operator. HTH
To test A1 againts range 100,200: =IF(AND(A1<=100,A1<=200),"In range","out range") There is no "between" operator. HTH
D David Biddulph Jun 15, 2006 #3 aries said: how do i use between instead of greater than or less than , in if then else statement Click to expand... If you're looking for A1 to be between B1 and C1, try =IF(AND(A1>B1,A1<C1),D1,E1)
aries said: how do i use between instead of greater than or less than , in if then else statement Click to expand... If you're looking for A1 to be between B1 and C1, try =IF(AND(A1>B1,A1<C1),D1,E1)
H Harlan Grove Jun 15, 2006 #4 aries wrote... how do i use between instead of greater than or less than , in if then else statement Click to expand... 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"
aries wrote... how do i use between instead of greater than or less than , in if then else statement Click to expand... 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"
G Guest Jun 15, 2006 #6 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.)
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.)
