IF Function

**kristinao** · 03-18-2011, 06:23 PM

I am building a spreadsheet that will put an "X" in the appropriate column that corresponds with the person's age.
For example: If the person is 15, I want excel to put an "x" in the Age 10-19 column. If they are 45, put an "x" in the the Age 40-49 column.
How do I write this formula??? I have tried an IF Function, but cannot get it to recognize the range (10-19, 40-49).

**TMS** · 03-18-2011, 06:28 PM

It will help others to help you if you post a sample workbook with some typical data and worksheet structure.

Regards

**Cutter** · 03-18-2011, 07:09 PM

Something like (for age 10 and up):

=IF(LEFT(age cell)=LEFT(header,1),"X","")

age cell is the cell containing the person's age

header is the cell containing the age range

or simplified version:

=IF(LEFT(age cell)=LEFT(header),"X","")

**bcsapper** · 03-18-2011, 09:29 PM

It seems to me like this is very similar to the problem I posted regarding the points of a compass and wind speed. (Posted today)

If you read my thread, Showing degrees of wind direction as compass point initials
there are some solutions and even a table you could adapt (posted by Cutter) to solve your problem.