Percentage of a Number in Excel: How to Calculate It

To find a percentage of a number in Excel, multiply the number by the percentage. For example, with a number in A2 and a percentage in B2, enter =A2*B2 in C2. If A2 is 250 and B2 is 15%, C2 returns 37.5. You can use a percentage entered in a cell or include it directly in a formula; the key is entering the percentage in the right form.

What You’ll Need

An Excel workbook in Microsoft Excel for Microsoft 365, on Windows, Mac, or the web.
A cell containing the number you want to calculate a percentage of.
The percentage you want to use, entered with a percent sign (such as 15%) or as a decimal (such as 0.15).

You do not need a special Excel function. Multiplication is enough for this calculation. If you are working with a list, arrange the numbers and percentages in columns so the formula can be copied down and checked easily.

Step-by-Step

Set up the cells. Put the number in one cell and the percentage in another. For a single example, enter 250 in A2 and 15% in B2. To enter a percentage, type the percent sign as part of the value. Excel interprets 15% as 0.15 for calculations, even though the cell displays 15%. You can also type 0.15 and format that cell as a percentage. Keeping the inputs separate makes it easier to change either value later.
Choose the result cell. Click an empty cell where you want the answer to appear, such as C2. With the number in A2 and the percentage in B2, enter =A2*B2 in C2. Press Enter. For the example values of 250 and 15%, the answer is 37.5 because 250 × 0.15 = 37.5. The formula starts with an equals sign so Excel treats it as a calculation.
Check the result’s number format. A portion of a number is usually best shown as a regular number, not as a percentage. If C2 displays 37.5, the calculation is complete. If it displays 3750%, the arithmetic may still be correct, but C2 has percentage formatting applied. Select C2 and change its format to General or Number using the Home tab’s Number controls. On Windows, the ribbon path is Home > Number > Number Format; choose General or Number. On Mac or in Excel for the web, use the Number Format control on the Home tab and choose General or Number. The formula works the same on those platforms.
Try a percentage typed directly in the formula. For a one-off calculation where the number is in A2 and the percentage is 15%, enter =A2*15% in C2. With 250 in A2, the result is 37.5. This is quick when the rate will not change, but a separate percentage cell is easier to update and makes the calculation more transparent to someone reviewing the worksheet.
Handle a percentage stored as a whole number. If B2 contains the number 15, not the percentage value 15%, then multiplying A2 by B2 would give 3,750. Divide by 100 to convert 15 to 0.15. With the number in A2 and the whole-number percentage in B2, enter =A2*B2/100 in C2. If A2 is 250 and B2 is 15, the result is 37.5. Use this version only when the percentage cell really contains 15 rather than 15%.
Apply the calculation to more rows. For a table with numbers in A2:A10 and percentages in B2:B10, enter =A2*B2 in C2, then copy the formula down through C10. Excel adjusts the row references so each answer uses the values on its own row. You can drag the small square at the lower-right corner of C2 down the column, or copy C2 and paste it into C3:C10. Check a couple of rows against a hand calculation before relying on the full column.

For example, if a table contains 250 and 15% in row 2, 80 and 20% in row 3, and 1,200 and 5% in row 4, the results are 37.5, 16, and 60. The percentage can differ in each row; the copied formula uses the matching percentage beside each number. If all rows use one fixed rate, see the tip about locking a reference below.

Common Mistakes

Multiplying by a whole number when Excel expects a decimal percentage. A value of 15% is stored as 0.15. If you type 15 in B2 and use =A2*B2, Excel calculates fifteen times the number, not fifteen percent of it. Either enter 15% in B2 or use the divide-by-100 version described above.

Formatting a whole number as a percentage. Formatting changes how a value is displayed; it does not convert 15 into 0.15. If you type 15 and apply Percentage format, Excel displays 1,500%. Enter 15% directly, or convert the whole-number input in the formula.

Formatting the answer as a percentage. The result of finding 15% of 250 is 37.5, which is an amount, not a rate. If the result cell has Percentage format, Excel displays 3,750%. Change the result to Number or General. Use Percentage format for the input rate, not automatically for the answer.

Using addition instead of multiplication. Adding 15 to 250 does not find 15% of 250. The calculation is number × percentage. For a discount or increase, there is an additional step to calculate the adjusted total; that is different from finding the percentage amount itself.

Copying a formula with mismatched rows. If the first result refers to A2 and B3 by mistake, filling it down will repeat the mismatch. Make sure both references point to the number and rate in the same row before copying.

Tips

Use clear headings. Label columns Number, Rate, and Percentage Amount, for example. This helps distinguish the rate (15%) from the calculated amount (37.5), especially when other people use the workbook.

Keep a shared rate in one cell. Suppose the number to calculate is in A2 and one fixed rate is in D1. With those cell locations, enter =A2*$D$1 in B2, then fill down. The dollar signs make D1 an absolute reference, so it stays fixed as the formula is copied. If A2 is 250 and D1 is 15%, B2 returns 37.5. Change D1 to update all the results.

Choose the display precision you need. Excel may display 37.5 as 37.50 if the result cell is set to two decimal places. This changes the display, not the underlying calculation. Use the increase or decrease decimal controls in the Home tab’s Number group if you need more or fewer displayed decimal places. Avoid rounding the formula unless the task specifically calls for a rounded result.

Use cell references for changing inputs. A formula such as =A2*B2 updates automatically if you change either input. A typed-in rate such as 15% is convenient for a quick calculation, but the rate is less obvious and can be harder to change consistently across a worksheet.

Distinguish the question you are answering. “What is 15% of 250?” asks for a portion, so multiply. “What percentage is 37.5 of 250?” asks for a rate, so divide the portion by the original number and format the result as a percentage. Those are related calculations, but they are not interchangeable.

Troubleshooting

The answer is 100 times too large. Check whether the percentage cell contains 15 instead of 15%. If it contains the whole number 15, use the formula that divides by 100, or replace the entry with 15%. Do not just change the result’s number format; formatting cannot correct the underlying calculation.

The result looks like a percentage with an extra two zeros. Select the result cell and check its number format. If it is Percentage, change it to General or Number. A result of 37.5 displayed as 3,750% is a formatting issue, not necessarily a wrong multiplication.

The formula appears in the cell instead of an answer. Make sure the entry begins with an equals sign and that the cell is not formatted as Text. Change the cell format to General, then re-enter the formula by selecting the cell, pressing F2, and pressing Enter. If Show Formulas is enabled, press Ctrl+` on Windows to toggle it off; on Mac, use Control+` if available on your keyboard, or check the Formulas tab for Show Formulas.

The result is zero or unexpectedly small. Inspect the input cells for unintended values, such as 0.15% instead of 15%, or a number stored as text. Click each input and look at the formula bar. Re-enter a percentage with the percent sign, such as 15%, and verify the formula points to the intended cells.

The copied results repeat the same number or use the wrong rate. Check that the formula uses relative references such as A2 and B2 when each row has its own inputs. If the rate should stay fixed, use an absolute reference such as $D$1 for that rate, while leaving the number reference relative. Then copy the formula again.

Frequently Asked Questions

What is the Excel formula for finding a percentage of a number?
Multiply the number by the percentage. With the number in A2 and 15% in B2, enter =A2*B2 in C2. If A2 is 250, C2 returns 37.5.

Do I enter 15 or 15% in the percentage cell?
For the usual formula, enter 15% (or 0.15) in the cell. Excel stores 15% as 0.15. If you enter 15 as a whole number, divide by 100 in the formula to convert it to a percentage rate.

How do I find 20% of 500 without using a separate percentage cell?
With 500 in A2, enter =A2*20% in B2. The result is 100. This is handy for a one-time calculation; use a separate rate cell if you need to change or reuse the percentage.

How do I find what percentage one number is of another?
This reverses the question: divide the part by the original whole, then format the result as a percentage. With the part in A2 and the whole in B2, enter =A2/B2 in C2. For 37.5 in A2 and 250 in B2, the result is 15% when C2 is formatted as Percentage.

Can I calculate a percentage of a number in Excel for Mac or the web?
Yes. The multiplication formula is the same in Excel for Microsoft 365 on Windows, Mac, and the web. The ribbon’s number-format controls may be arranged or labeled slightly differently; use the Home tab’s Number Format control to choose Number for the result or Percentage for a rate.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.