Formula with 3 Criteria

		Microsoft Office Forums > Microsoft Excel > Excel
Formula with 3 Criteria

FAQ

Thread Tools

Display Modes

09-24-2013, 09:08 AM

bremen22

Windows 7 64bit Formula with 3 Criteria

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?

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:27 PM.