[MarcS]

I have a Word 2007 table that allows a user to enter a 1 character Text Form Field in a cell. The Text Form Field has been bookmarked with the name "Question1". The word document is protected to enable only "Filling in forms" type editting. They can enter either the letters A, B, C or D as a result of a multiple choice. In another cell, I want to create a formula that will return a number based on the letter the user entered. For example; A=1, B=2, C=3 and D=4. When the user tabs out of the Text Form Field the cell containing the formula is updated automatically.

Would appreciate any help with this

[nananaja003]

I've managed to resolve by using a nested if function with.
gclub royal