Thread: Nested What If statement using date ranges

Originally Posted by Glenn1

Hello,

I am trying to create a nested what if statement in excel using multiple date ranges. For example:

If Cell X > 12/2/2009 but less than 12/31/2011 return 0-3

If Cell X > 12/2/2006 but less than 12/2/2009 return 3-5

If Cell X > 12/2/2001 but less than 12/2/2006 return 5-10

If Cell X < 12/2/2001 return over 10

The what if statement I created rerutrns the same answer regardless what is in Cell X
=IF(J31>="12/2/2009"&J31<"12/31/2011","0-3",IF(J31>="12/2/2006"&J31<"12/2/2009","",IF(J31>="12/2/2001"&J31<"12/2/2006","5-10",IF(J31<="12/2/2001","over 10"))))

Please help

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.