How to write a function formula
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 |
How to write a function formula
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 |
All times are GMT +1. The time now is 09:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com