SmittenKitten

this is what I do all day long, darlin..

I'm not sure of a way without VBA code where you can type a value in the cell and have it display another value in that same cell. With Excel there isnt a Yes and No value, there's True and False, with 1 being True and 0 being false

I was born in Ironton, lived there until '89. I would love to see this city turn around.

For example. If I highlight cell C1 and go to Data|Validation and change the Allow: value to "List" by clicking on the down arrow and typing "<25,26-45, 46-64, Over 64" into the box labeled Source (without quote marks). Then clicked ok. This will make it so when I click on C1, a drop down arrow appears allowing me to choose one of those options. Then in another cell (in my test file I used C3) I used the following formula, =IF(ISBLANK(C1),"",IF(C1="<25",1,IF(C1="26-45",2,IF(C1="46-64",3,4)))) What this does is first, checks to see if it's blank, if it is, it leaves C3 blank. Then it checks to see if the value in C1 is <25, if it is, it puts a 1, if it's not, it checks for the next option, and the next, etc until you have your 4 options covered. Is that what you're looking to do?

are you wanting it so that they have a dropdown to choose their age group and it displays a number 1-4 in another cell? if you want, we can discuss this via email

Radeona...Congrats on passing the assessment tests! :clap: congrats! I agree with the more women comment. It'll be great to have another female in the place

Yeah.. my husband .... before him, there wasnt a rule about swords in the office... :)

Another PCH geek here, although the husband and I wont be starting until Aug 1st. The pictures here look great! I'm really getting antsy to get back there. (I grew up in Southern Ohio) Werrf, yes, bring the chocolate.. and I'll even warm the kettle for you