How Percentage Calculations Work
A percentage is a fraction out of 100. “Per centum” in Latin means “by the hundred.”
That framing makes the three common percentage problems much easier to follow.
What Is X% of Y?
This is the most common calculation. You have a percentage and a total number, and you want the actual value that percentage represents.
Formula: Result = (Percentage / 100) x Number
Example: What is 15% of $80?
- 15 / 100 = 0.15
- 0.15 x 80 = $12
Real-world use: your restaurant bill comes to $80 and you want to leave a 15% tip. The tip is $12.
Another example: a store offers 25% off a $200 item. The discount is 25/100 x 200 = $50, so you pay $150.
X Is What Percent of Y?
You have two numbers and want to express the relationship between them as a percentage.
Formula: Percentage = (Value / Total) x 100
Example: You scored 42 out of 60 on an exam. What percentage is that?
- 42 / 60 = 0.70
- 0.70 x 100 = 70%
Real-world use: your sales team closed 18 out of 30 leads this month. They converted 60% of leads.
Percentage Change
This one tells you how much something increased or decreased relative to where it started.
Formula: Change = ((New Value - Original Value) / |Original Value|) x 100
If the result is positive, the value went up. If it is negative, it went down.
Example 1: Monthly revenue went from $4,200 to $5,460.
- 5,460 – 4,200 = 1,260
- 1,260 / 4,200 = 0.30
- 0.30 x 100 = +30% increase
Example 2: A stock drops from $85 to $68.
- 68 – 85 = -17
- -17 / 85 = -0.20
- -0.20 x 100 = -20% decrease
The vertical bars around “Original Value” in the formula mean absolute value. You divide by the size of the original, regardless of whether it is positive or negative. This matters when you are tracking changes in things like net profit, which can go negative.
How to Use This Calculator
The calculator has three tabs at the top, one for each type of percentage problem.
Tab 1 — What is X% of Y? Enter the percentage in the first box and the number in the second. The result appears as you type. Good for discounts, tips, tax amounts, and commission calculations.
Tab 2 — X is what % of Y? Enter the value first, then the total. You get the percentage that the first number represents of the second. This is what you want for grades, completion rates, and market share.
Tab 3 — % Change Enter the original value and the new value. The calculator shows how much it changed as a percentage, with a bar chart comparing the two numbers side by side. Use this for period-over-period comparisons, investment returns, or any before-and-after situation.
You do not have to click Calculate. Results update in real time as you type. The Calculate button is there as a fallback if you prefer to confirm your inputs before seeing the result.
How to Calculate Percentages in Excel
Excel does not have a single dedicated percentage function. You only need basic arithmetic formulas. Excel’s percentage formatting handles most of the display work for you.
What Is X% of Y? in Excel
If A1 contains the percentage (e.g., 25) and B1 contains the number (e.g., 200):
=A1/100*B1
If A1 is already formatted as a percentage cell (showing 25% but storing 0.25 internally), use:
=A1*B1
Excel stores percentage-formatted cells as decimals. 25% is actually 0.25 in the cell. The format just adds the % symbol and moves the decimal point visually. This catches a lot of people off guard when they write formulas.
X Is What Percent of Y? in Excel
Put the value in A1 and the total in B1:
=A1/B1
Then press Ctrl + Shift + % to format the result as a percentage. Do not multiply by 100 in your formula. If you do, Excel will display something like 7000% instead of 70% because the percentage format already multiplies by 100 for display.
Related tutorial: Convert Number to Percentage in Excel
Percentage Change in Excel
Put the original value in A1 and the new value in B1:
=(B1-A1)/ABS(A1)
Format the result as a percentage with Ctrl + Shift + %. The ABS() function in the denominator keeps things correct when the original value is negative. Without it, dividing by a negative number flips the sign of your result.
Gotcha: If A1 is zero, this formula returns a #DIV/0! error. Wrap it in IFERROR:
=IFERROR((B1-A1)/ABS(A1), "N/A")
Common Percentage Mistakes to Avoid
Confusing percentage points with percentage change. This one shows up constantly in financial reporting and news articles. If an interest rate goes from 4% to 6%, that is a 2 percentage point increase. The actual percentage change in the rate is 50%, not 2%. Saying “the rate went up 2%” is technically wrong. Percentage points are just the arithmetic difference between two percentages. Percentage change is the relative change.
Adding stacked discounts directly. If a product is 20% off and you have an additional 10% coupon, the total discount is not 30%. The second discount applies to the already-reduced price. If the original price is $100: after 20% off it is $80, then 10% off $80 is $72. The actual total discount is 28%, not 30%. This same logic applies to compounding raises.
Using the wrong base for percentage change. Percentage change divides by the original value, not the new one. If sales went from 200 to 250, the change is (250-200)/200 = 25%, not (250-200)/250 = 20%. Dividing by the new value is a different calculation called “percentage of total” and gives a smaller number.
Forgetting how Excel stores percentage cells. When you type 25% into a cell formatted as a percentage, Excel stores 0.25. If you then reference that cell in a formula and also divide by 100, you are off by a factor of 100. Always check whether your cell contains 25 or 0.25 before writing the formula.
Assuming a percentage decrease undoes a percentage increase. It does not. Start with 100, increase by 50%: you get 150. Now decrease 150 by 50%: you get 75. The base changes between the two operations, so you cannot simply reverse a percentage change by applying the same percentage in the opposite direction. To get back to 100 from 150, you need a 33.3% decrease, not 50%.
Frequently Asked Questions
What is the formula for calculating a percentage?
It depends on what you need. To find X% of a number Y, use: Result = (X / 100) x Y. To find what percent X is of Y, use: Percentage = (X / Y) x 100. To find percentage change between two values, use: Change = ((New – Original) / |Original|) x 100.
How do I calculate a 20% discount on a price?
Multiply the original price by 0.80. That gives you the sale price directly. For example, 20% off $65 is $65 x 0.80 = $52. Alternatively, calculate the discount amount first: $65 x 0.20 = $13, then subtract: $65 – $13 = $52. Both approaches give the same answer.
What is the difference between percentage change and percentage difference?
Percentage change compares a new value to an original value and requires knowing which one came first. It can be positive (increase) or negative (decrease). Percentage difference compares two values without designating either as the starting point, and it always produces a positive number. Use percentage change for before-and-after comparisons; use percentage difference when comparing two things that exist at the same point in time.
Why does my percentage not add up to 100%?
Rounding is almost always the cause. If you calculate each percentage separately and round each result to a whole number, the individual rounded figures often sum to 99% or 101%. This is normal. You can fix it by leaving one category as “remainder” rather than rounding it, or by rounding only the final number after summing.
How do I find the original price before a discount?
Divide the sale price by (1 – discount rate). For example, a jacket costs $68 after a 20% discount. The original price was $68 / 0.80 = $85. In Excel: =A1/(1-B1) where A1 is the sale price and B1 is the discount percentage formatted as a percentage cell.
Can a percentage exceed 100%?
Yes, in many contexts. A 150% increase means the new value is 2.5 times the original. Revenue growing from $1 million to $4 million is a 300% increase. Percentages above 100% appear regularly in growth metrics, overcapacity measurements, and performance targets. A percentage can only not exceed 100% when it represents a share or proportion of a whole, like market share or completion rate.
Related Articles / Calculators:
