substitute a Letter (code) for an pre-set value
Posted by Hugo Simoes on August 14, 2001 2:15 PM
Hey guys!!! First of all I wanna thank y'all for the help with my past request and i also hope i can get help this time as well. Y'all do a fantastic job.
Would it be possible for me to have for example, in column A, a smoker/non-smoker tab, and all i wanna enter in that field is "Y" for yes and "N" for no. If they enter "y", i'd like either that same cell or in a different one to show a pre-set value.
Explaining a little better:
- In cell A1 i have the smoker/non-smoker tab.
- Either on the same cell, or in a diff one, i'd like the computer to be able to show those pre-set values as soon as it reads my "Y" or "N".
Hopefully u guys will get it, and i'll be grateful once again.
Thank you for your time!