Home 
Search 
Today's Posts 
#1




How do I set up formula in a table to calculate a percentage
How do I set up formula in a table to calculate a percentage?
I am getting a syntax error message when I input the formula. 
#2




It would be helpful if you would show us the formulat that's producing the
error. There is a variety of ways to do this, and it'd help to know which one you're trying. If you're calculating using numbers, for example, the following works, if you want to know what 75 is as a percentage of 120 ({} are field delimiters inserted by pressing Ctrl+F9): {= 100*75/120} If 75 and 120 are associated with bookmarks named subtotal and total, then the following would work: {= 100*subtotal/total} If you're referencing cells in the table as if they were spreadsheet cells, then a different notation is needed, such as: { =100*a1/b1 } In this case, a1 refers to column 1, row 1 and b1 refers to column 2, row 1. I hope this helps.  Herb Tyson MS MVP Please respond in the newsgroups so everyone can follow along. http://www.herbtyson.com "Jams" wrote in message ... How do I set up formula in a table to calculate a percentage? I am getting a syntax error message when I input the formula. 
Reply 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Forum  
Table headers/footers and layout  Page Layout  
How to Avoid Word 2003 Table Style Problems  Tables  
How do you create a formula in a table where the result appears a.  Tables  
Table AutoFormats vs. Table Styles confusion  Tables  
Formula in table  Creating a final total from subtotal cells  Tables 