google sheets formula for subtracting a percentage

Master Google Sheets: Subtract Percentages with Ease!

By Amanda Lewis
AD

When working with Google Sheets, calculating subtractions is a breeze. But what if you need to subtract a percentage from a value? That's where Google Sheets' powerful formula language comes into play. Let's dive into how you can subtract a percentage from a value using Google Sheets formulas.

Before we get started, let's assume we have two values: A1 contains the value 100 (the amount from which we need to subtract a percentage), and B1 contains the percentage to be subtracted, let's say 20%.

Subtracting a Percentage from a Value

Google Sheets allows us to subtract a percentage by using the PERCENTOF function. However, this function is not as straightforward as it sounds. Let's break down the process into two main steps.

AD
How to Calculate Percentage Increase in Google Sheets: 3 Easy Formulas
How to Calculate Percentage Increase in Google Sheets: 3 Easy Formulas
How to Easily Calculate Percentages in Google Sheets: A Step-by-Step Beginner’s Guide
How to Easily Calculate Percentages in Google Sheets: A Step-by-Step Beginner’s Guide
How to Calculate Percentage in Google Sheets
How to Calculate Percentage in Google Sheets

The first step is to convert the percentage into a decimal using the PERCENTOF function. The second step involves subtracting this decimal from the initial value.

Converting Percentage to Decimal

To convert the percentage in cell B1 (20%) into a decimal (0.20), we use the following formula in a new cell, say C1:

Percentage Formula Sheet | Bank PO, SSC, Railway & Aptitude Notes
Percentage Formula Sheet | Bank PO, SSC, Railway & Aptitude Notes
percentage formula
percentage formula
20 Google Sheets Formulas Everyone Should Know (Save This!)
20 Google Sheets Formulas Everyone Should Know (Save This!)

`=PERCENTOF(B1, 100)`

Here, 100 is the divisor by which the percentage is divided to get the decimal. In this case, 20% becomes 0.20.

AD

Subtracting the Decimal from the Value

Now, to subtract the decimal from the value in A1 (which is 100), we use the standard subtraction formula in D1:

an info sheet showing the percentage of different types of meats
an info sheet showing the percentage of different types of meats
How to Subtract in Google Sheets with a Formula
How to Subtract in Google Sheets with a Formula
Percentage Formula Chart | Quick Revision, Shortcuts & Solved Examples for Competitive Exams
Percentage Formula Chart | Quick Revision, Shortcuts & Solved Examples for Competitive Exams
How To Calculate Percentage in Google Sheets
How To Calculate Percentage in Google Sheets
Google Sheets SUM Formula: Add Numbers Instantly
Google Sheets SUM Formula: Add Numbers Instantly
Percentage (%) Mathematics Formula Sheet | A to Z Complete Guide for Students & Competitive Exams
Percentage (%) Mathematics Formula Sheet | A to Z Complete Guide for Students & Competitive Exams

`=A1 - C1`

This gives us the result of 80, which means 20% of 100 has been subtracted from the original value.

AD

Subtracting a Percentage from a Range of Values

We can extend this process to subtract a percentage from a range of values. Let's assume we have values from A2 to A100, and we want to subtract 20% from each of these values.

the text reads,'get the sheet 100 + formulas'and an image of a
the text reads,'get the sheet 100 + formulas'and an image of a

To do this, we drag the formula from D1 (our result) across the range A2:D100. Here's how to do it:

Applying the Formula to a Range

First, click on cell D1 to select it. Then, hover over the small square in the bottom right corner of the cell until the cursor turns into a plus sign (+). Drag this down to cell D100. This will apply our formula to cells D2 through D100, subtracting 20% from each value in the range A2:A100.

AD

Google Sheets makes complex calculations, like subtracting a percentage from a value, simple and efficient. With a bit of practice and knowledge of these formulas, you can streamline your spreadsheets and save time.

As always, happy calculating! Remember, Google Sheets is a powerful tool, and learning its formulas opens up a world of possibilities for your data analysis and manipulation. The more you practice, the more proficient you'll become. Now go ahead and explore the endless possibilities in your Google Sheets!

AD