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

excel

ResolvedVersion 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:

Double click for Paragraph dialog box

Double-click an indent marker to open the Paragraph dialog box

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.