[Fritman99]

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.

[macropod[_2_]]

Hi Fritman99,

Word's formula syntax isn't the same as Excel's, plus an OR statement in Word can deal with only two conditions.

To see how to do a wide range of other calculations in Word, check out my Word Field Maths Tutorial, at:
http://www.wopr.com/index.php?showtopic=365442
or
http://www.gmayor.com/downloads.htm#Third_party

For your particular calculation, you could use a formula field coded as:
{IF{=A1+A2+A3+A4+A5+A6} 0 {=AVERAGE(A1:A6)}}

Note: The field brace pairs (ie '{ }') for the above example are created via Ctrl-F9 - you can't simply type them or copy & paste
them from this message.

--
Cheers
macropod
[Microsoft MVP - Word]


"Fritman99" wrote in message ...
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.