#1
|
|||
|
|||
Help with Word 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 Excel syntax for that formula in Word? Thanks so much. |
#2
|
|||
|
|||
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 |
Tags |
excel, form, formula, table, word |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Number formatting in Word table | 8braitp | Word Tables | 0 | 08-27-2009 04:12 AM |
How to add Table of Content in word document by C# ! ! ! | arun singh | Word | 0 | 11-12-2008 11:21 PM |
word catalog table layout problem... | turk1130 | Word Tables | 0 | 08-01-2006 11:56 AM |
Word mail merge and formula | mridley | Mail Merge | 0 | 04-30-2006 11:26 AM |