Remember Me?

Posted to microsoft.public.word.tables
 Fritman99 external usenet poster Posts: 1 Help with Word 2003 table formula

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.

Posted to microsoft.public.word.tables
 macropod[_2_] external usenet poster Posts: 2,059 Help with Word 2003 table formula

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

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.

 Thread Tools Show Printable Version Display Modes Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Posting Rules Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Microsoft Word Newsgroups     Microsoft Word Help     New Users     Tables     Formatting Long Documents     Mailmerge     Page Layout About WordBanter     About this forum Similar Threads Thread Thread Starter Forum Replies Last Post Cindi Tables 1 May 22nd 09 01:20 AM Ray Tables 8 October 21st 07 03:17 AM Mark Microsoft Word Help 2 April 6th 06 06:51 AM Kathleen Tables 2 November 1st 05 07:49 AM Terry Tables 1 June 5th 05 08:59 AM

All times are GMT +1. The time now is 11:53 PM. Copyright ©2004-2023 Microsoft Office Word Forum - WordBanter.