excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Word Training and help » Excel

Excel

resolvedResolved · High Priority · Version 2003

Paula has attended:
Word Intermediate course

Excel

How do I convert sums to %

Edited on Fri 13 Jun 2008, 15:04

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

 

Training courses

 

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Word tip:

WORK menu

To add the Work menu to the menu bar or a toolbar:

On the Tools menu, click Customize, and then click the Commands tab.
In the Categories box, click Built-in Menus.
Click Work in the Commands box and drag it to the menu bar or displayed toolbar.
With the Work menu in place, you can add any open Word document to your list. Here are the options:

To add the current document to the Work menu, on the Work menu, click Add to Work Menu.
To open a document on the Work menu, on the Work menu, click the document you want to open.
To remove a document from the Work menu:
Press CTRL+ALT+- (dash key). Your cursor will look like a large, bold underscore.
On the Work menu, click the document you want to remove.

View all Word hints and tips


Server loaded in 0.08 secs.