Formula with 3 Criteria

[bremen22]

I am trying to find formula to to show the following result:

if AD2 is between 0 and 10 "1-10 Days"
if AD2 is between 11 and 20 "11-20 Days"
if AD2 is over 20 the "Over 20 Days"




I have found some formulas but none of them ever seem to work right?

[BobBridges]

What not just a multiple IF statement?

=IF(AD2>20,"Over 20",IF(AD2>10,"11-20","1-10"))&" Days"

That should work if your values are always going to be positive integers.

[bremen22]

All of the formulas I found were a lot more complicated than that.....

And that did the trick. Thank you.

[Pecoflyer]

Alternative solution allowing to use ranges which can be easily adapted

=LOOKUP(A2,{0,10,21},{"1-10","11-20","Over 20"})&" Days"

Just enter the different elements in cells ( say B1:B3 and C1:C3)

Then

 =LOOKUP(A2,B1:B3,C1:C3)&" Days"