If you need to figure out a rate, share, discount, or change in Google Sheets, the fastest answer is to put the right formula in the cell and format the result as a percentage. Once you know how to calculate percentage in Google Sheets, you can handle everything from simple percent-of-total math to percentage increase and decrease without leaving the spreadsheet.
Calculate a basic percentage from two numbers
To find a percentage in Google Sheets, divide the part by the total, then format the result as a percent. For example, if A2 is the part and B2 is the whole, the formula is straightforward.
- Click the cell where you want the result.
- Enter =A2/B2.
- Press Enter.
- Click Percent format on the toolbar, or use Format then Number then Percent.
If A2 contains 25 and B2 contains 100, the result displays as 25%. If you leave the cell in plain number format, Sheets shows 0.25, which is the same value before percentage formatting.
Use percentage formulas for real spreadsheet tasks
Find percent of a total
When you want to calculate percentage Google Sheets style for a category share, divide the category value by the total. For example, if sales in A2 are 45 and total sales in B2 are 180, use =A2/B2. Format the answer as a percentage to show 25%.
This is the standard percentage in Google Sheets formula for shares, ratios, and completion rates. If you need the result as a decimal instead of a percent, leave the number format as plain number.
Create a percentage formula in Google Sheets
You can also build a percentage formula directly from a calculation. For example, to find what percent 18 is of 72, use =18/72. To pull values from cells, use references like =B3/C3 so the formula updates when numbers change.
If you want the formula to copy down a column, use relative references. Drag the fill handle down and Sheets adjusts the row numbers automatically, which is the simplest way to calculate percentage in Google Sheets across many rows.
Calculate percentage increase and decrease
To calculate percentage increase Google Sheets users compare the new value to the old value, then divide the difference by the old value. This gives the percent change, which is the right formula for price changes, growth, and losses.
- Put the old value in A2 and the new value in B2.
- Enter =(B2-A2)/A2.
- Format the cell as a percentage.
If the old price is 80 and the new price is 100, the formula returns 25%. For a decrease, the result becomes negative. If A2 is 100 and B2 is 80, the result is -20%.
How to subtract percentage in Google Sheets
To subtract a percentage from a number, multiply the number by one minus the percentage. If A2 is 200 and B2 is 15%, use =A2*(1-B2). That gives 170.
If you want the plain percentage amount removed instead of the final total, use =A2*B2. For the same example, that returns 30. This is the clearest way to handle discounts, tax removal, and reductions.
How to add percent in Google Sheets
Adding a percentage to a number uses multiplication, not simple addition. If A2 is 200 and B2 is 15%, use =A2*(1+B2). That returns 230.
To calculate percent in Google Sheets for markup, commission, or tax, this formula is the standard choice. If you only want the added amount, use =A2*B2. That returns 30 in the same example.
How to convert to percentage in Google Sheets
When your sheet already shows decimals and you want them displayed as percentages, change the format rather than rewriting the formula. A result of 0.42 becomes 42% after formatting.
- Select the cells.
- Click Percent format on the toolbar, or open Format, then Number, then Percent.
- If needed, use the increase or decrease decimal buttons to show one or two decimal places.
This is how to put percentage in Google Sheets after calculations, and it works for formulas such as shares, rates, and percent change. The underlying value stays the same, only the display changes.
Common percentage formula patterns
Calculate percentage of a total
Use =part/total. Example, =A2/B2.
Calculate percent increase
Use =(new-old)/old. Example, =(B2-A2)/A2.
Calculate percent decrease
Use the same formula as increase. A negative result shows the decrease.
Apply a discount or surcharge
Use =value*(1-percent) for subtraction and =value*(1+percent) for addition.
If you need a formula to calculate percentage Google Sheets can reuse across rows, keep the cell references consistent and fill the formula down the column. That is the fastest way to handle percentages in reports, budgets, sales sheets, and trackers.
Frequently Asked Questions
How do I calculate percentage in Google Sheets without a calculator?
Divide the part by the whole, then format the cell as a percentage. For example, =A2/B2 shows 25% when A2 is 25 and B2 is 100.
What is the percentage in Google Sheets formula for percent change?
Use =(new-old)/old. This is the standard formula for growth, decline, and change over time.
How do I calculate percentage on Google Sheets from a list of values?
Put the item value in one cell and the total in another, then divide the item by the total. Copy the formula down for each row if the total stays in the same pattern.
How do I use percentage in Google Sheets for discounts?
Multiply the original value by one minus the discount rate. For example, =A2*(1-B2) applies a discount stored in B2.
How do I compute percentage in Google Sheets and show it correctly?
Use the formula first, then apply percent formatting. Without the format, Sheets shows decimals instead of percentage signs.
Related Posts:
Google Sheets
- How to Search in Google Sheets
- Google Sheets Formula: If a Cell Contains Text
- How to Use COUNTIF in Google Sheets
- How to View Hidden Sheets and Rows in Google Sheets
- How to Insert an Image Into a Cell in Google Sheets
- How to Merge Cells in Google Sheets
- How to Insert a Hyperlink in Google Sheets
- How to Calculate Days Between Dates in Google Sheets
- Google Sheets Formulas: The Essentials With Examples
- How to Delete Multiple Google Sheets at Once
- How to Add or Remove Borders in Google Sheets
- How to Convert Currency in Google Sheets
- Google Sheets Won’t Let You Edit: Fixes
- How to Delete Columns in Google Sheets
- How to Link Google Sheets to Google Calendar
- How to Reference Another Sheet in Google Sheets
- How to Change Cell Color With a Formula in Google Sheets
- How to Calculate Totals in Google Sheets
- How to Multiply in Google Sheets
- How to Change Row Height in Google Sheets
- How to Alphabetize in Google Sheets
- How to Save Google Sheets to Your Computer
- How to Build a Budget in Google Sheets
- How to Freeze Rows and Columns in Google Sheets
- How to Remove Gridlines in Google Sheets
- How to Lock a Formula or Cell in Google Sheets
- How to Hide Formulas in Google Sheets
- Google Sheets Not Showing Tabs: Fixes
- How to Convert Google Sheets to Excel
- How to Change Cell Width in Google Sheets