View Single Post
  #2   Report Post  
Herb Tyson [MVP]
 
Posts: n/a
Default

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.