I'm not 100% sure which forum this would be under, but I'm trying to create a template/form. In the form there are four different options to choose from, lets say A, B, C and D. Option A=1 B=2 C=3 and D=4. If the user marks the box in option A, I want the number 1 to come up in the total column of the form. Same thing for B would be 2, C would be 3 and D would be 4. Is there a way to get this in the form? If not, what about using excel? I'm trying to streamline an evaluation form at work and I have to get it done sooner than later.

Any help you can provide would be greatly appreciated.

-schiesa