Thread: [Solved] Formula with 3 Criteria
View Single Post
 
Old 09-24-2013, 09:12 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit 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