calculating profits

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculating profits

Calculating profits

resolvedResolved · High Priority · Version 2007

Michael has attended:
Excel Introduction course

Calculating profits

How to calculate %

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


 

Excel tip:

Checking formulas with multiple operators

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

B = brackets
E = exponents
D = division
M = multiplication
A = addition
S = subtraction

It should be noted that multiplication and division are considered equal; as are addition and subtraction.

If you would like to check the order in which Excel is performing calculations in a formula, simply click on the cell containing the formula. Then go to Tools - Formula Auditing and select Evaluate Formula.

In the Evaluate Formula dialogue box that appears on your screen, click the Evaluate button to see how Excel calculates the formula result.

View all Excel hints and tips


Server loaded in 0.12 secs.