#1
|
|||
|
|||
Formula with 3 Criteria
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? |
#2
|
||||
|
||||
What not just a multiple IF statement?
Code:
=IF(AD2>20,"Over 20",IF(AD2>10,"11-20","1-10"))&" Days" |
#3
|
|||
|
|||
All of the formulas I found were a lot more complicated than that.....
And that did the trick. Thank you. |
#4
|
||||
|
||||
Alternative solution allowing to use ranges which can be easily adapted
Code:
=LOOKUP(A2,{0,10,21},{"1-10","11-20","Over 20"})&" Days" Then Code:
=LOOKUP(A2,B1:B3,C1:C3)&" Days"
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Display if search criteria is not met | meppwc | Excel | 2 | 03-23-2013 10:48 AM |
AND function be used as criteria in DB functions? | 56_kruiser | Excel | 10 | 12-06-2012 02:59 PM |
Sorting by certain criteria | randenius | Excel | 2 | 06-11-2012 02:18 AM |
Countif with 2 criteria | ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |
Criteria in Outlook Search | Nancy Grams | Outlook | 0 | 11-12-2009 03:03 PM |