Changing text based on another cell's number

**Cori_W** · 05-08-2014, 05:10 PM

I am a somewhat beginner at Excel. I work at a clinic that uses a spreadsheet for their clients.... The clients only have to fill out a questionaire when they are above 6 years old... One column on this spreadsheet has the dates that the last questionaire was done and if the kid is under 6 we type Under 6... and there's another column with their age (based on a formula). Is there any way to have the questionaire column to put "Under 6" automatically when the age column is under 6 years old and leave the cell alone when they're over 6. Some of the cells for the over 6 clients have different due dates in them and I don't want that to change, if that makes sense. Hopefully this isn't too confusing and has enough information.

**windy58** · 05-08-2014, 05:21 PM

A sample sheet would help it would give a better understanding of what you are after. (just a sheet with a few examples of what you have)

**AlKey** · 05-08-2014, 06:31 PM

You did not say anything if they are 6. Should the formula say "Under 6".

Here is a formula that will show clients with under 6

=IF(A2="","",IF(A2<6,"Under 6",""))

	A	B
1	Age	Is Under 6
2	5	Under 6
3	7
4	8
5	4	Under 6
6	6

**Cori_W** · 05-16-2014, 10:43 AM

excel.jpg

The sample spreadsheet is attached. I want the PYOQ column to change to the date of today when the child turns 6. And I want the CYOQ column to change to date of today when the child turns 12. I want to fill the formula through the whole spreadsheet and I don't want the formula to manipulate the values already there (like the PYOQ/CYOQ dates of the over 6 and 12 year olds already there).

**Cori_W** · 05-16-2014, 10:49 AM

Some of the clients already have a date the questionaire is due because they're already over 6. How would I make sure the cell doesn't go blank? I don't want the formula to manipulate it if it doesn't apply.