How do I set up formula in a table to calculate a percentage

J

Jams

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.
 
H

Herb Tyson [MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top