Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-31-2009, 06:54 PM
fritman99 fritman99 is offline Help with Word table formula Windows XP Help with Word table formula Office 2003
Novice
Help with Word table formula
 
Join Date: Aug 2009
Posts: 1
fritman99 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 09-02-2009, 05:36 PM
zyzzyva57 zyzzyva57 is offline Help with Word table formula Windows 7 32bit Help with Word table formula Office 2007
Expert
 
Join Date: Mar 2009
Location: Dawsonville, Ga (NE of Atl)
Posts: 355
zyzzyva57 is on a distinguished road
Default

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
Reply With Quote
Reply

Tags
excel, form, formula, table, word

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft