IF less than = Text, IF Greater than but less than = Text, If Greater than = Text

[Zabelle]

Hello,

I have been looking for a formula and still get errors!

If F2 <=110 = Short term OR
IF F2 >111 OR F2<220 = Medium term OR
IF F2>221= Long term

I am looking for one formula with the 3 possibles results.

Thank you in advance for your help!

Zab

 

[MARK858]

Going by yor description maybe...

=IF(F2<=110,"Short term",IF(AND(F2>111,F2<220),"Medium term","Long term"))

but what is supposed to happen if the value is 111 or 220 or 221 (please note the last 2 I have guessed at in the formula)?

 

[sandy666]

maybe:

=IFNA(CHOOSE(MATCH(F2,{0,111,221},1),"Short","Medium","Long"),"")

if your excel doesn't support IFNA() function use IFERROR()

adjust values if necessary

 

[Zabelle]

Thank you! Thank you! You are right I am missing the = sign, but It work!

=IF(F2<=110,"Short term",IF(AND(F2>=111,F2<220),"Medium term",IF(F2>221,"Long term")))