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: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
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,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
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"
__________________
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
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

All times are GMT -7. The time now is 03:26 PM.


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