Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 sub-total cells | Tables |