The basic formula for percentage of amount

To find what percentage one number is of another in Excel, divide the first number by the second, then multiply by 100. The formula is =(A1/B1)*100, where A1 is the amount you're measuring and B1 is the total amount.

For example, if you sold 45 items out of 200 total items, you would enter =45/200*100 to get 22.5%. Excel does the division first, then multiplies the result by 100 to convert it to a percentage.

You can also skip the *100 and format the cell as a percentage instead — Excel will display the decimal as a percentage automatically. So =A1/B1 formatted as percentage gives the same result as =(A1/B1)*100 formatted as a number.

Key Takeaways

  • The percentage formula is =(amount/total)*100, or you can use =amount/total and format the cell as a percentage.
  • Always put the smaller number (the part) in the numerator and the larger number (the whole) in the denominator.
  • Use dollar signs like $B$1 to lock a cell reference if you plan to copy the formula down to other rows.
  • The formula works the same way whether your numbers are in cells or typed directly into the formula bar.

Setting up your spreadsheet with sample data

Start by entering your data in two columns. Put the amount you want to measure in one column (say, column A) and the total amount in another column (say, column B). For instance, if you're tracking sales by region, column A might show regional sales and column B might show total company sales.

Click on the cell where you want the percentage to appear — usually column C, in the same row as your data. This is where you'll enter the formula. If your amount is in A2 and your total is in B2, you'll type the formula in C2.

Entering the percentage formula step by step

Step 1: Click on the cell where you want the result to appear.

Step 2: Type the equals sign to start the formula: =

Step 3: Type the cell reference for the amount, then a forward slash, then the cell reference for the total. For example: =A2/B2

Step 4: Type *100 to convert the decimal to a percentage, or press Enter and format the cell as a percentage instead.

Step 5: Press Enter. Excel calculates the result and displays it in the cell.

Using percentage formatting instead of multiplying by 100

If you use the formula =A2/B2 without multiplying by 100, Excel shows the result as a decimal — for example, 0.225 instead of 22.5%. To display this as a percentage, right-click the cell and select Format Cells. In the Format Cells dialog, click the Number tab, select Percentage from the Category list, and click OK.

Excel automatically multiplies the decimal by 100 and adds the percent symbol. This method is cleaner because the formula is simpler and you can easily change how many decimal places appear. To adjust decimal places, right-click the cell again, select Format Cells, and change the number in the Decimal Places field.

Both methods give the same visual result. Choose whichever feels more natural to you — some people prefer the explicit *100 in the formula, while others prefer letting the percentage format handle the conversion.

Copying the formula to multiple rows

If you have many rows of data, you don't need to type the formula in each cell. Enter the formula once in the first data row, then copy it down to the other rows. Click the cell with your formula, then drag the small square at the bottom-right corner of the cell down to the last row where you need the calculation.

Excel automatically adjusts the cell references as it copies. If your first formula is =A2/B2, the second row becomes =A3/B3, the third becomes =A4/B4, and so on. This works because the references are relative — they shift based on the row.

If you want a formula to always reference the same cell (for example, always dividing by a total in B1), use dollar signs: =$A2/$B$1. The dollar signs lock that reference so it doesn't change when you copy the formula down.

Calculating percentage change between two numbers

Percentage change is different from percentage of amount. To find how much a number changed as a percentage, use the formula =((new value - old value) / old value) * 100. For example, if sales were 100 last month and 150 this month, the percentage change is ((150-100)/100)*100, which equals 50%.

The key difference is that you subtract the old value from the new value first, then divide by the old value. This tells you the rate of increase or decrease. If the result is negative, the value decreased. If it's positive, the value increased.

Common mistakes and how to avoid them

The most common mistake is reversing the numbers — putting the total in the numerator and the amount in the denominator. This gives you a number larger than 100%, which is usually wrong. Always remember: the smaller number (the part) goes on top, and the larger number (the whole) goes on the bottom.

Another mistake is forgetting to multiply by 100 or format as a percentage, then wondering why your result looks like 0.225 instead of 22.5%. If you see a decimal when you expect a percentage, either add *100 to your formula or format the cell as a percentage.

A third mistake is using absolute references (dollar signs) when you shouldn't. If you copy a formula down and want the column references to change but the row to stay the same, use =$A2 (locks the column) or =A$2 (locks the row). Use $A$2 only when you truly want both to stay locked.

Frequently Asked Questions

Do I need to multiply by 100 if I format the cell as a percentage?

No. If you format the cell as a percentage, use the formula =A1/B1 without the *100. Excel automatically multiplies by 100 and adds the percent symbol. If you include *100 in the formula and format as percentage, you'll get a result like 2250% instead of 22.5%.

What if my total is zero?

Excel shows a #DIV/0! error because you cannot divide by zero. To avoid this, use an IF statement: =IF(B1=0,0,(A1/B1)*100). This tells Excel to show 0 if the total is zero, otherwise calculate the percentage normally.

Can I calculate percentage of amount with negative numbers?

Yes, the formula works the same way. If you have -50 as the amount and 200 as the total, the result is -25%. The negative sign carries through the calculation. Make sure the negative number is in the right place — if you meant the total to be negative, adjust accordingly.

How do I show percentages with two decimal places?

Right-click the cell with the percentage, select Format Cells, click the Number tab, choose Percentage from the Category list, and set Decimal Places to 2. Click OK. Excel will display all percentages in that column with exactly two decimal places.

What's the difference between =A1/B1*100 and =(A1/B1)*100?

There is no difference in the result. Both formulas calculate the same way because multiplication and division have equal priority in Excel — they are evaluated left to right. The parentheses in the second version make the order clearer to read, but Excel produces the same answer either way.