I have a survey, some questions are Yes/No and some questions have multiple
choice answers that are assigned different point values.

In analyzing the answers, I want to be able to type in the answer (ie,
Yes/No or choice a or choice a and b and have Excel assign a point value
depending on the answer. (ie, If I type in Yes, then hit Enter, I want the
cell to have a "1" in it.)

Is that possible?

Mike