Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-24-2013, 09:08 AM
bremen22 bremen22 is offline Formula with 3 Criteria Windows 7 64bit Formula with 3 Criteria Office 2007
Advanced Beginner
Formula with 3 Criteria
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Question 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?
Reply With Quote
  #2  
Old 09-24-2013, 09:12 AM
BobBridges's Avatar
BobBridges BobBridges is offline Formula with 3 Criteria Windows 7 64bit Formula with 3 Criteria Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 676
BobBridges will become famous soon enoughBobBridges will become famous soon enough
Default

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.
Reply With Quote
  #3  
Old 09-24-2013, 09:43 AM
bremen22 bremen22 is offline Formula with 3 Criteria Windows 7 64bit Formula with 3 Criteria Office 2007
Advanced Beginner
Formula with 3 Criteria
 
Join Date: Jul 2013
Posts: 44
bremen22 is on a distinguished road
Default

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

And that did the trick. Thank you.
Reply With Quote
  #4  
Old 09-24-2013, 11:39 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Formula with 3 Criteria Windows 7 64bit Formula with 3 Criteria Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,423
Pecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to allPecoflyer is a name known to all
Default

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"
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula with 3 Criteria Display if search criteria is not met meppwc Excel 2 03-23-2013 10:48 AM
Formula with 3 Criteria 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
Formula with 3 Criteria 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

Other Forums: Access Forums - Senior Forums

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


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft