To calculate percentages in Excel, choose the operation that matches the question: multiply an amount by a rate to find a portion, divide the part by the total to find a proportion, and divide the difference by the starting value to find a change. Excel stores 18% as 0.18; Percentage format changes how the value is displayed, not how the calculation works.
| Goal | Cells | Formula | Expected result |
|---|---|---|---|
| Calculate 18% of 480 | B2 = 480; C2 = 18% | =B2*C2 | 86.40 |
| Find what share 39 is of 60 | B2 = 39; C2 = 60 | =B2/C2 | 65% |
| Increase 1,250 by 7.5% | B2 = 1250; C2 = 7.5% | =B2*(1+C2) | 1,343.75 |
| Apply a 12% discount to 840 | B2 = 840; C2 = 12% | =B2*(1-C2) | 739.20 |
| Measure the change from 320 to 368 | B2 = 320; C2 = 368 | =(C2-B2)/B2 | 15% |
The formulas use cell references so you can replace the inputs without rewriting the calculation. If you only need an immediate answer, use the percentage calculator. When one term in a proportion is unknown, the rule of three calculator may be more direct.
How to calculate a percentage of an amount
Place the base amount in B2, the rate in C2, and enter =B2*C2 in D2. With 480 in B2 and 18% in C2, the result is 86.40.
You can enter 18% directly or enter 0.18 and apply Percentage format. Do not multiply by 100 again: the rate already participates in the calculation as 0.18. If the rate cell contains 18 without the percent sign, the formula will use eighteen times the base amount, not eighteen percent.
How to find what percentage a part is of the total
When you know the part and the total, divide the part by the total. With 39 in B2 and 60 in C2, use =B2/C2. The stored result is 0.65; after Percentage format is applied, the cell displays 65%.
The total belongs in the denominator. Reversing the formula to =C2/B2 answers a different question and produces a value above 100% in this example. If the total may be zero, handle that case explicitly: =IF(C2=0,"",B2/C2) leaves the cell blank instead of displaying #DIV/0!. A percentage of a zero total should not be invented as 0%.
Increase, discount, and change between two values
To apply a rate to the base amount itself, use 1 to represent 100% of the original amount:
- Increase: =B2*(1+C2).
- Discount: =B2*(1-C2).
- Increase or discount amount only: =B2*C2.
With 1,250 and 7.5%, the increased amount is 1,343.75. With 840 and 12%, the discounted amount is 739.20. These results include the base amount; simple multiplication returns only the percentage portion.
To measure the change between a starting value in B2 and a final value in C2, use =(C2-B2)/B2 and apply Percentage format to the result. From 320 to 368, the difference is 48, and 48 divided by 320 is 15%. When the starting value is positive, a lower final value produces a negative result. This formula uses the signed starting value as its denominator; with a negative base, interpret the sign in the context of your metric before comparing the change.
When the starting value is zero, relative percentage change is undefined. A defensive formula is =IF(B2=0,"",(C2-B2)/B2). The blank is only a presentation choice: you can display a message or send those rows for review instead.
How to copy the formula without moving the rate
Suppose the changing amounts are in B2:B20 and the single 6% rate is in F1. In C2, use =B2*(1+$F$1) and fill down. B2 is a relative reference and becomes B3, B4, and so on; $F$1 is an absolute reference and continues pointing to the same rate.
If a copied formula changes unexpectedly, select the cell and inspect which references moved. Lock only the cells that must remain constant; making every reference absolute prevents the table from advancing through its rows.
Percentage formatting and separators
Percentage format multiplies only the displayed value by 100 and adds the % sign. That is why 0.18 appears as 18%, while an existing value of 18 appears as 1800% after formatting. Microsoft documents this behavior, and it explains many results that are one hundred times larger than expected. There is an important distinction: if an empty cell is already formatted as Percentage, entering 18 makes Excel interpret it as 18% and display 18.00%. To avoid ambiguity, enter 18% directly or use 0.18 before applying the format.
Select the rate or result cell and choose Percentage in the Number group. Changing the displayed decimal places does not round the stored value that other formulas use.
English Excel examples normally use a period as the decimal mark and commas between function arguments, as in =IF(B2=0,"",(C2-B2)/B2). Arithmetic formulas that only contain references, such as =B2*C2, need no argument separator. If your Excel installation uses another regional setting, follow the separator shown in its existing formulas.
Common mistakes and how to check them
- Result is 100 times too large: the rate was entered as 18 instead of 18% or 0.18.
- #DIV/0!: the total or starting value used as the denominator is blank or zero.
- Formula is displayed as text: remove a leading apostrophe, change the cell format from Text to General, and confirm the formula again.
- Result changes when copied: the rate cell needed an absolute reference such as $F$1.
- Decimal places are hidden: the visual format changed, but Excel still calculates with the stored value.
- Unexpected sign in a change: confirm which cell contains the starting value and which contains the final value.
Verified results
The examples were run through Calculaderia's current percentage functions and compared with separately defined expected results. The checks returned 86.40 for 18% of 480; 65% for 39 out of 60; 1,343.75 for a 7.5% increase on 1,250; 739.20 for a 12% discount on 840; and 15% for the change from 320 to 368. The same check returned 84.80 and 127.20 for the two rows using a fixed 6% rate, and flagged a change whose starting value is zero as undefined.
These tests check the arithmetic, not a run in Excel itself. If your workbook differs, inspect the cells' actual values, formatting, regional separator, and copied references first.