Home Up Excel Cheat Sheet
Need some math reminders to complete your Excel assignments? Review a needed topic by following the links:

Hierarchy of Math Operations | Comparison Operators | Calculation Help | Calculating a Percent Change | Math with Percentages | Link to Help with Decimals, Percentages and Fractions

Hierarchy of Math Operations
Excel performs math in a particular order. You need to remember to order when developing formulas.
Parenthesis
Exponents
Multiplication  Division
Addition  Subtraction
Need help remembering the order? Try this:
Please Excuse My Dear Aunt Sally.

Comparison Operators

Greater than >
Less than <
Greater than or equal >=
Less than or equal <=
Not equal <>


Calculation Help

You are often called upon to calculate percentages or find rates. This simple trick can help you recall how to perform these calculations.
Consider the following diagram:

P
B * R

P = Portion (part of the whole)
B = Base (the total, or the whole thing)
R = Rate (decimal, or a percentage)

Cover the piece you are trying to calculate, and do the math on the pieces that remain.

(to top)

Example 1: I want to find the percentage (rate) that sales of widgets contributed to my total sales.

I know the portion (the widget sales) and the base (the total sales)

I'm trying to calculate the rate.

Cover the R, and the math that remains is:

P
B

If I sold 75 widgets and had total sales of 150 items, the math is:

75
150

Answer: .50, or 50%
50% of my total sales were widgets

(to top)

Example 2: I know the total, and I know the percentage a particular item contributed, but I want to know the number sold of that item.

I sold 150 items; 40% (.40) were widgets. How many widgets did I sell?

I am trying to calculate the portion. Cover the P and the math that remains is:

B*R

Answer: 150 * .40 = 60

(to top)

Example 3: I know that I sold 70 widgets, and that widgets represent 25% (.25) of my total sales. What were my total sales?

I am trying to calculate the base. Cover the B and the math that remains is:

P
R

Answer: 70/.25 = 280
I had total sales of 280 units.

Finding a Percentage of Change
This year I sold 100 units. Last year I sold 80 units. By what percentage did my sales increase?

First, you must calculate the change in units:

This year - Last Year
100 - 80 = 20 units difference

Next, I divide the change in units by last year's number.

20/80 = .25 (25%)

There has been a 25% increase in sales between last year and this year. I can check my work by multiplying last year's sales by the increase, and adding that amount to last year's sales.

80 * .25 = 20   80+20 = 100

or, the shortcut:

80 *1.25 = 100

(to top)

Math with Percentages
 

It is good practice to express percentages in decimal notation.

To convert a number expressed as a percentage, to a number expressed as a decimal:

Move the decimal point two places to the left. Add a 0 (zero) as a placeholder if necessary, and drop the %.

This % Becomes this decimal
27% .27
113% 1.13
4.5% .045

To covert a number expressed as a decimal, to a number expressed as a percentage:

Move the decimal point two places to the right. Remove leading zeros and add the % sign.

This decimal Becomes this %
.45 45%
.03 3%
.125 12.5%

Remember that 100%, or 1.00, represents all of a particular value. When I make a change to the value, I have to work from the basis of the original 100%. First, calculate the change in percentage (expressed as a percentage), then convert to decimal notation, then write the expression.

I raise my price by 15%. What is the new price?

Current Price 100%
PLUS price increase 15%
New Price 115%
Convert to decimal 1.15
Equation Current Price * 1.15
   

I want to offer a 22% discount to certain customers. How do I calculate the amount I charge them?

Current cost 100%
MINUS the discount 22%
New Cost 78%
Convert to decimal .78
Equation Current Price * .78
   

I want to offer a 22% discount to certain customers. How much of a discount will I offer them?

Discount 22%
Convert to decimal .22
Equation Current Cost * .22

Read each problem carefully to determine if you are to calculate the new value or the change in value. When calculating the new value you have to take the existing value into consideration.

(to top)
 

Links to Math Help

Help with Decimals, Percentages, Fractions
Quick Percentages Review
Self-Test Your Understanding

(to top)
 

| Wittman's Web Home | CIS 106 | CIS 108 | CIS 109 | CIS 160 | Links | Instructor Bio | SVCC Home
(c) 2004-06 by Val Wittman       Email me at: wittmav@svcc.edu