Reply
 
Thread Tools Display Modes
  #1   Report Post  
Jams
 
Posts: n/a
Default 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   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.



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Table headers/footers and layout Keith Page Layout 1 April 8th 05 07:37 PM
How to Avoid Word 2003 Table Style Problems Judy Haynes Tables 0 March 23rd 05 06:41 PM
How do you create a formula in a table where the result appears a. papa did Tables 1 March 11th 05 09:49 PM
Table AutoFormats vs. Table Styles confusion Tony Jollans Tables 5 March 6th 05 07:18 PM
Formula in table - Creating a final total from sub-total cells Anne Gilmour Tables 1 November 7th 04 04:14 AM


All times are GMT +1. The time now is 09:48 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"