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 Excel Training and help » best training excel intermediate - Percentages on excel
best training excel intermediate - Percentages on excel
Resolved · Low Priority · Version Standard
Lavon has attended:
Excel Introduction course
Percentages on excel
What is the formula for entering percentages in a cell?
RE: Percentages on excel
Hi Lavon
Thank you for your question.
When you want to create a percentage in Excel, the rule of thumb is to take the part and divide by the whole.
For example, if you have sales for Quarter 1 and total sales for the whole year, and you want to find out what percentage sales for Quarter 1 were of the whole year, you divide the sales for Quarter 1 by the total sales for the whole year.
Then you need to format the cell where you've put the formula as a percentage (Format - Cells - Number then choose Percentage and OK).
I hope this helps.
Amanda
Training information:
See also:
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. |
Excel tip:Display Functions on WorksheetsFunctions in Excel can be difficult to recall their format/syntax |