98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculating profits
Calculating profits
Resolved · High Priority · Version 2007
Wed 18 Jun 2008, 16:42Delegate Michael said...
Fri 20 Jun 2008, 10:44Trainer Amanda said...
RE: calculating profits
Hi Michael
Thank you for your question; and welcome to the forum.
To create a percentage, you need to have a value; and an overall total.
For example, if you had sales for each quarter then an overall total for the whole year, you would create a formula that takes the figure for say, quarter 1, and divides this figure by the overall total.
Type in = first, then select the figure for quarter 1, type in / and then select the overall figure. Press Enter.
You will get the result as a decimal to start with. If you select the cell showing the decimal result, then go to Format - Cells - Number tab. Select Percentage from the categories on the left, set how many decimal places you would like displayed on the right, and click OK. Your result should show as a % now.
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:Checking formulas with multiple operatorsWhen dealing with formulas containing more than one operator (+, -, /, *), Excel follow standard BEDMAS order of operation rules. These rules specify the order that calculations will be performed in, regardless of how the formula reads left to right: |
