I have an IF/AND statement that seems to only be reading the first part of
the formula. I'm trying to get a value to categorize in one of the three
separate columns..
Scenario: The statements I created categorizes the age (value) 31, in the
category of "between 15 and 31 days" and in the category labeled "30 days"

Here is the scenario as laid-out in EXCEL€¦
Cell A1=Start Date 1/28/2005
Cell B1=End Date 2/25/2005
Cell-C1 = Formula to calculate AGE in days (=b1-a1)
Cell D1 = Formula to identify if cell c1 is between 0 - 15 days
(=IF((c1<16),"0-15","")
Cell E1 = Formula to identify if cell c1 is between 15 and 30 days
(=IF(AND(c115,c1<31),"16-30","")
Cell F1 = Formula to identify if cell c1 is 30 days (=IF((X230),"31+","")

Why is it triggering cell E1 and F1. It should only appear in F1 because it
is 30 days.
Let me know Thanks-Greg