Using IF () Statement to Find Values Between

[eopoku]

I'm using IF statement to determine if a condition evaluates to Short (if value<4), Medium (if value between 4 and 9), or Long (if value =>10). The "Medium" statement gives me "FALSE" instead of "Medium". I'm sure I'm doing something wrong. Here is what I did and a sample results. Thanks for your help.

=IF(A1<4,"Short",IF(A1>=4<=9,"Medium",IF(A1>=10,"Long")))
-----------
LOS LOS1
4 FALSE
8 FALSE
10 Long
5 FALSE
3 Short
2 Short
5 FALSE
6 FALSE
6 FALSE
14 Long
11 Long
5 FALSE
6 FALSE
3 Short
3 Short

[Fotis1991]

Hi

Use AND statement for this.

Please Login or Register  to view this content.

[Ace_XL]

Maybe..

=IF(A2<4,"Short",IF(A2<=9,"Medium",IF(A2>=10,"Long","")))

[oeldere]

Another approach

C2 =

Please Login or Register  to view this content.

See the attached file (the green cells).

[newdoverman]

Here is another variation:

Please Login or Register  to view this content.

[Tony Valko]

Here's another one...

Entered in B2 and copied down:

=LOOKUP(A2,{0;4;10},{"Short","Medium","Long"})

[eopoku]

Thanks a lot!