How do I calculate percentage of a number in Google Sheets?

Use the formula =A1*B1 where A1 is the number and B1 is the percentage as a decimal (0.15 for 15%). Or use =A1*15% directly — Google Sheets understands the % sign. Example: =500*15% returns 75. Format the result cell as a number, not percentage.

How do I calculate percentage change in Google Sheets?

Formula: =(new_value - old_value) / old_value. Then format the cell as percentage. Example: old value in A1 ($1,500), new value in B1 ($1,650). Formula: =(B1-A1)/A1 returns 0.1 which displays as 10% when formatted as percentage.

How do I calculate percentage of total in Google Sheets?

Formula: =A1/SUM(A:A) for a single column. Or =A1/B1 where B1 is the total. Format as percentage. Example: if cell A1 has 25 and the column total is 200, =A1/SUM(A$1:A$10) returns 12.5%.

How do I format cells as percentage in Google Sheets?

Select the cells, then Format > Number > Percent. Or use the % button in the toolbar. Google Sheets multiplies the cell value by 100 for display — so 0.15 shows as 15%, and 1.5 shows as 150%. If you type 15 and format as percentage, it shows 1500%. Enter 0.15 or type 15% directly.

When should I use Google Sheets vs an online calculator?

Use Google Sheets when you have a column of numbers and need percentages for each row — the formula copies down automatically. Use an online calculator for a single quick calculation where opening a spreadsheet is overkill. Google Sheets is a tool for data; a calculator is a tool for quick answers.

Can I calculate percentage without Google Sheets?

Yes. A browser-based percentage calculator handles all three types (percentage of, what percentage, and percentage change) without needing a spreadsheet. It is faster for single calculations — type two numbers, get the answer. No formulas, no formatting, no spreadsheet required.

Percentage Calculator in Google Sheets — Every Formula You Need

Last updated: April 20266 min readCalculator Tools

Google Sheets calculates percentages with simple formulas: =A1*15% for percentage of a number, =(B1-A1)/A1 for percentage change, =A1/SUM(A:A) for percentage of total. For a single quick calculation without opening a spreadsheet, the percentage calculator is faster.

Every Percentage Formula in Google Sheets

What You Need	Formula	Example	Result
15% of 500	=500*15%	=A1*B1 (B1 contains 0.15 or 15%)	75
What % is 45 of 200?	=45/200	=A1/B1, format as %	22.5%
% change: 1500 to 1650	=(1650-1500)/1500	=(B1-A1)/A1, format as %	10%
% of total	=A1/SUM(A$1:A$10)	Format as %	Varies
Add 20% to a number	=A1*(1+20%)	=500*1.2	600
Subtract 30% from a number	=A1*(1-30%)	=500*0.7	350
% difference between 2 values	=ABS(A1-B1)/((A1+B1)/2)	Format as %	Varies

Need a quick percentage? Skip the spreadsheet.

Open Percentage Calculator

Common Google Sheets Percentage Mistakes

Formatting trap: If you type "15" in a cell and format as percentage, Google Sheets shows "1500%" — it multiplies by 100. Enter "0.15" or "15%" instead
Division by zero: =(B1-A1)/A1 throws #DIV/0! if A1 is 0. Wrap it: =IF(A1=0,"N/A",(B1-A1)/A1)
Percentage of total with blank rows: =A1/SUM(A:A) includes every row in column A. Use a specific range like A1:A50 to avoid counting headers or blank cells
Mixing formats: If column A has raw numbers (0.15, 0.22) and column B has formatted percentages (15%, 22%), formulas mixing them will produce wrong results. Keep formatting consistent

Google Sheets vs Online Calculator — When to Use Each

Scenario	Google Sheets	Online Calculator	Better Choice
Single quick calculation	✗ Open Sheets, type formula	✓ Open page, enter numbers	Online calculator
Calculate % for 50 rows	✓ Formula copies down column	✗ One at a time	Google Sheets
Budget tracking with %	✓ Auto-updates	✗ No saved data	Google Sheets
Test score percentage	~Overkill for one score	✓ Instant answer	Online calculator
Sales commission %	✓ Handles full team data	✗ One person at a time	Google Sheets
Tip calculation	✗ Opening Sheets for a tip?	✓ Instant	Online calculator

Advanced: Conditional Percentage Formatting

Google Sheets can color-code percentage results automatically:

Select your percentage column
Format > Conditional formatting
Set rules: green if > 0 (positive growth), red if < 0 (decline)
This creates instant visual dashboards for sales, grade, or budget data

An online calculator does not offer this — it is a one-shot tool. For ongoing data analysis with visual feedback, Google Sheets wins.

Related Tools

Percentage Calculator — instant percentage math, no spreadsheet
Discount Calculator — percentage off sale prices
Tip Calculator — percentage-based tips
Salary Calculator — convert salary with percentage raises
Excel Viewer — view spreadsheets in your browser
Excel to CSV — convert spreadsheet data
Column Operations — process data columns

For a quick percentage, the calculator beats opening a spreadsheet.

Open Percentage Calculator

Percentage Calculator in Google Sheets — Every Formula You Need

Every Percentage Formula in Google Sheets

Common Google Sheets Percentage Mistakes

Google Sheets vs Online Calculator — When to Use Each

Advanced: Conditional Percentage Formatting

Related Tools

Related Posts

Percentage Calculator vs Excel

Percentage Calculator Guide

How to Calculate Percentage

Percentage Calculator Reddit