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 syntax for that formula in Word? Thanks so much.

I've never tried a complex formula in Word before and was surprised about how few examples I was able to find via the Word Help files and/or Google. Anyway, through trial and error, I ended up getting this to work:

=IF(OR(A1=1,A2=1),1,IF(OR(A3=1,A4=1),1,IF(OR(A5=1,A6=1),1,AVERAGE(A1:A6))))

I couldn't find any way to get OR to look at any more than 2 arguments without getting a Syntax error on the comma.

Maybe you could try your question here:

http://groups.google.com/group/micr...

You'll have to register first.

P.S. Don't use the "" around the 1 or you'll get a Syntax error on that also.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History