RE: excel

Hi Paula

Thank you for your question; and welcome to the forum.

I am assuming that you want to create a percentage in a table in Word.

To do this:
1. Click in the cell where you wish to display the %age
2. Go to Table - Formula.
3. In the Formula box leave the = but delete the SUM and anything following.

4. Enter your formula to calculate the %
Each of the cells in the table have a reference, starting with cell A1 in the top left corner of the table.

If you are familiar with Excel then this will make sense to you. The leftmost column is column A, the second column is column B etc. The top row is row 1, second row is row 2 etc.
Each cell is referred to by the column letter first then the row number second (hence cell A1 for the cell in the top right corner).

You enter the reference for the cell that you want to change to a %, then enter the / symbol for divide, then type in the reference for the cell that contains the grand/overall total, e.g.

=A3/C3

Then put brackets around this: =(A3/C3)

And multiply by 100: =(A3/C3)*100

In the number format box, choose which % style you want to use: 0% will display to the nearest whole number; 0.00% will display to two decimal places.

Click OK.

I've attached an example for you to look at.

With formulas in tables, you have to force them to update if any of the figures in the table change.

To do this, select the formula result and press F9.

I hope this helps.
Amanda

Attached files...

table with formulas.doc