I am creating a form in Word 2003 includes a table for calculating personnel evaluation ratings. The user will use the table to input whole number grades into cells A1 through A6; the numerical grades for each cell range from 1 (unacceptable) to 5 (outstanding). The rules of our evaluation system say that the final rating will be an average of the six grades entered, unless one of them is a 1. In that case the final rating must be a 1.



I want to add a formula to cell A7 that will calculate the final rating for the grades entered following those rules. I have been able to create a formula in Excel that works: =IF(OR(A1=1, A2=1, A3=1, A4=1, A5=1, A6=1),"1",AVERAGE(A1:A6)), but when I create a field in cell A7 in Word and add that formula to it, I get a syntax error because of the commas. Can anyone help me with the right Excel syntax for that formula in Word? Thanks so much.

Set it up in Excel

Copy it

Go to Word and use Paste Special

Then you may have to set the Numbering to General in Word