98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Word Training and help » Excel
Excel
Resolved · High Priority · Version 2003
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...
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:WORK menuTo add the Work menu to the menu bar or a toolbar: |