Microsoft Office Forums Formula with 3 Criteria
 Register FAQ Search Today's Posts Mark Forums Read

#1
09-24-2013, 09:08 AM
 bremen22 Windows 7 64bit Office 2007 Advanced Beginner Join Date: Jul 2013 Posts: 44
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
09-24-2013, 09:12 AM
 BobBridges Windows 7 64bit Office 2010 32bit Expert Join Date: May 2013 Location: USA Posts: 676

What not just a multiple IF statement?
Code:
`=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.
#3
09-24-2013, 09:43 AM
 bremen22 Windows 7 64bit Office 2007 Advanced Beginner Join Date: Jul 2013 Posts: 44

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

And that did the trick. Thank you.
#4
09-24-2013, 11:39 AM
 Pecoflyer Windows 7 64bit Office 2010 64bit Expert Join Date: Nov 2011 Location: Brussels Belgium Posts: 2,423

Alternative solution allowing to use ranges which can be easily adapted
Code:
`=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
Code:
` =LOOKUP(A2,B1:B3,C1:C3)&" Days"`

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post meppwc Excel 2 03-23-2013 10:48 AM 56_kruiser Excel 10 12-06-2012 02:59 PM randenius Excel 2 06-11-2012 02:18 AM ibrahimaa Excel 3 05-23-2011 11:23 AM Nancy Grams Outlook 0 11-12-2009 03:03 PM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 10:04 AM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top