A spreadsheet with percentage formulas and a small calculator on a deep purple background

How to Calculate Percentage in Excel and Google Sheets (Formulas + Examples)

A shopkeeper wants to know what 15% off Rs. 2,400 is. A teacher needs each student’s marks as a percentage. A freelancer has to add 17% tax to an invoice. In all three cases the maths is the same — and in a spreadsheet it takes one short formula instead of a calculator and a notebook.

Excel and Google Sheets calculate percentages in exactly the same way, with the same formulas. Once you know the three basic patterns — a percentage of a number, a percentage increase, and a percentage decrease — you can answer almost any percent question in seconds, and the spreadsheet recalculates instantly when a number changes.

The basic percentage formula

The idea behind every percentage calculation is a simple division: part divided by total, times 100. In a spreadsheet you write it as a formula.

To find what percentage one number is of another: =A2/B2

If A2 holds 45 (marks obtained) and B2 holds 60 (total marks), the formula gives 0.75. That is the decimal form of 75%. To see it as a percentage, format the cell as a percentage (see below) and it will show 75%.

To calculate a percentage of a number — for example, 15% of 2,400: =2400*15%

In a spreadsheet, typing 15% in a formula means 0.15, so this gives 360. The same works with cell references: if the price is in A2 and the discount rate in B2, use =A2*B2% — or, if B2 already contains 0.15, simply =A2*B2.

The general pattern to remember: percentage = part / total, and amount = total × rate. Every other formula in this guide is one of these two with a small twist.

If you only need a one-off answer without opening a spreadsheet, the free Percentage Calculator on this site gives the same result instantly — handy for a quick check before you build the full sheet.

Formatting cells as percentages

A common beginner mistake is getting 0.75 when you expected 75%. The calculation is right; the display is wrong. The cell is showing the decimal, not the percentage.

In both Excel and Google Sheets, select the cell, then:

  • Excel: press Ctrl + Shift + %, or click the % button on the Home tab, or use Format Cells → Percentage.
  • Google Sheets: click Format → Number → Percent, or press Ctrl + Shift + 5 (on some keyboards).

Formatting changes only how the number looks, not its value — 0.75 stays 0.75 underneath, so you can still use it in other formulas. You can also choose how many decimal places to show: 75% or 75.00% are the same number.

One warning: if you type 75 into a cell that is already formatted as a percentage, the spreadsheet reads it as 75% — but if you then multiply it, it uses 0.75, which is correct. The confusion starts when people type 0.75 into a percent-formatted cell and see 75%, then type 75 and see 7500%. Type the number as a percentage (75), not as a decimal, when the cell is already formatted that way.

Percentage increase and decrease

These are the two formulas people look up most — sale prices, pay rises, price hikes and growth rates.

Percentage increase — a price rises from Rs. 800 to Rs. 920: =(B2-A2)/A2

With the old price in A2 (800) and the new price in B2 (920), the result is 0.15, shown as 15% after formatting. The pattern is always (new − old) / old.

Percentage decrease — a Rs. 2,400 item is now Rs. 2,040: =(A2-B2)/A2

Same pattern, just the other way round: (old − new) / old gives 0.15, or 15% off.

Finding the new value after a percentage change:

  • After a 15% increase on 800: =A2*(1+15%) → 920
  • After a 15% decrease on 2,400: =A2*(1-15%) → 2,040

The 1+15% trick is worth memorising: it means “the whole original amount plus 15% of it” in a single step. For the background and more worked examples of increase and decrease, see How to Calculate Percentage Increase and Decrease.

Worked examples you can copy

Example 1: Discount on a shop bill

A jacket costs Rs. 3,500 and the shop offers 20% off. In the sheet:

  • A2: 3500 (price)
  • B2: 20% (discount rate)
  • Discount amount: =A2*B2 → 700
  • Price to pay: =A2*(1-B2) → 2,800

Example 2: Student marks as a percentage

A student scores 432 out of 500:

  • A2: 432, B2: 500
  • Percentage: =A2/B2 → format as % → 86.4%

Example 3: Adding tax to an invoice

A service costs Rs. 12,000 and tax is 17%:

  • A2: 12000, B2: 17%
  • Total with tax: =A2*(1+B2) → 14,040
  • Tax amount alone: =A2*B2 → 2,040

Example 4: A tip on a restaurant bill

The bill is Rs. 2,400 and you want to leave a 10% tip:

  • =2400*10% → 240 tip, =2400*(1+10%) → 2,640 total

Example 5: Monthly growth

Website visitors grew from 1,200 in October to 1,560 in November:

  • =(1560-1200)/1200 → 30% growth

For a whole column of values, write the formula once in the first row, then drag the fill handle down — the cell references adjust automatically for each row. Use $ to lock a reference that should not move, for example =A2*$B$2 keeps B2 fixed while A2 changes down the column.

Common errors and how to fix them

  • #DIV/0! — you divided by zero or by an empty cell. Check that the total cell actually contains a number. In a marks sheet, this usually means the total-marks cell is blank.
  • The answer is 100 times too big (7500% instead of 75%). You typed 75 into a cell already formatted as a percentage, or you multiplied by 100 as well as formatting as %. Pick one: either format as % and use the plain ratio, or leave the cell as a number and multiply by 100 yourself.
  • The answer is 100 times too small (0.75% instead of 75%). The cell is formatted as a percentage but the value is already a percentage number — for example, you typed 0.75 meaning 75% and the sheet shows 0.75%. Type 75, not 0.75, in a percent-formatted cell.
  • The formula shows as text instead of calculating. The cell is formatted as Text, or you typed a space or an apostrophe before the =. Change the format to General and retype the formula.
  • Wrong result after copying a formula down. A reference moved that should have stayed fixed. Lock it with $, for example $B$2 for a tax rate that applies to every row.

Frequently asked questions

What is the formula to calculate percentage in Excel?

Divide the part by the total: =A2/B2, then format the result cell as a percentage. For example, 45 out of 60 is =45/60, which shows as 75% once formatted. To find a percentage of a number, use =2400*15%, which gives 360.

How do I calculate percentage increase in Google Sheets?

Use =(new-old)/old. If the old value is in A2 and the new value in B2, the formula is =(B2-A2)/A2. Format the result as a percentage. For example, a rise from 800 to 920 is =(920-800)/800, which is 15%.

How do I format a cell as a percentage in Excel?

Select the cell and press Ctrl + Shift + %, or click the % button on the Home tab. In Google Sheets, use Format → Number → Percent. Formatting only changes the display — the value underneath stays the same, so other formulas still work correctly.

Why does my Excel percentage show as a decimal like 0.75?

The calculation is correct; the cell is simply not formatted as a percentage. A value of 0.75 is the decimal form of 75%. Apply percentage formatting to the cell and it will display as 75%.

What is the formula for percentage decrease in Excel?

Use =(old-new)/old. With the old price in A2 and the new price in B2, the formula is =(A2-B2)/A2. To find the new price directly after a 15% decrease on 2,400, use =2400*(1-15%), which gives 2,040.

Conclusion

Percentage maths in a spreadsheet comes down to three formulas: part divided by total for a percentage, (new − old) / old for an increase or decrease, and total × (1 ± rate) for the new value after a change. Format the answer cell as a percentage, watch out for the decimal-versus-percent trap, and let the spreadsheet do the rest — change any input number and every answer updates itself. That is the real advantage over a calculator: build the sheet once, and it answers the same question correctly every time.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *