I need a formula that satisfies the following:
From an excel spreadsheet I have a colum that contains the ages of different
residences. The ages are 1) New (less than a year) 2) The rest has a range
from 1 to 100 years. I want to call this new column "Age". The column "K"
contains the data and the first row is #35. Wherever there is a NEW I want
to call it 0. Ages from 47 to 100 I want to call it 1. Ages from 30 to 46 I
want to call it 2. Finally ages from 0 to 29 I want to call it 3.
I think I need to revise first column "K" for the value of 0 for all "NEW".
Otherwise I will have problems with the designation of the three groups.

Thank you for your help,
Ramon Luis

With an age in A1, try:

=IF(A1="New",0,(A146)+(A129)*(A1<47)*2+(A1<30)*3 )

--
Gary''s Student - gsnu200781


"Raymond L" wrote:

I need a formula that satisfies the following:
From an excel spreadsheet I have a colum that contains the ages of different
residences. The ages are 1) New (less than a year) 2) The rest has a range
from 1 to 100 years. I want to call this new column "Age". The column "K"
contains the data and the first row is #35. Wherever there is a NEW I want
to call it 0. Ages from 47 to 100 I want to call it 1. Ages from 30 to 46 I
want to call it 2. Finally ages from 0 to 29 I want to call it 3.
I think I need to revise first column "K" for the value of 0 for all "NEW".
Otherwise I will have problems with the designation of the three groups.

Thank you for your help,
Ramon Luis