IF/AND Formula seems to only be reading 1st part of formula

[Guest]

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(c1>15,c1<31),"16-30","")
Cell F1 = Formula to identify if cell c1 is >30 days (=IF((X2>30),"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

 

[CLR]

Besides the typeo(?) of X2 in the F1 formula............the whole thing
seems to work for me in XL2k........except 1/28/05 - 2/25/05 is 28 days, not
30, so it lights up E1 like it's supposed to........huh?

Vaya con Dios,
Chuck, CABGx3

 

[Ron Rosenfeld]

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(c1>15,c1<31),"16-30","")
Cell F1 = Formula to identify if cell c1 is >30 days (=IF((X2>30),"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

Last I checked, 28 (b1-a1) was less than 30, so it should trigger in E1.

Also, your formula in F1 is checking X2, and you do not report the contents of
that cell, but likely it has a value >30


--ron