Subtracting numbers in real life is a no-brainer. We learn to do this so early in life that we never even think of it as a skill. The advent of calculators has made it easier to subtract even large numbers.

Subtracting data values in Google Sheets, on the other hand, is a whole other thing.

When you’re dealing with large amounts of data, it becomes impractical to use your calculator to perform subtractions one at a time. In fact, why bother working on data one at a time when you can perform thousands of subtractions in one go?

Google Sheets uses *Formulas *and *Functions *to help you subtract.

In this tutorial, we will show you two quick ways in which you can **subtract cell values in Google Sheets**.

## How to Subtract in Google Sheets

Google Sheets and more or less all spreadsheet software thrive on functions and formulas. Both provide excellent ways to perform calculations and obtain results. That’s precisely why, out of all the different ways in which you can subtract on Google Sheets, we have chosen to highlight these two methods.

To understand how to quickly subtract cell values in Google Sheets, we are going to use the following dataset:

In this dataset, we want to subtract each *Expenditure *value (column B) from each *Income *value (column A) and put the resultant *Balance *in column C.

### Method 1: Subtracting in Google Sheets Using a Simple Formula

A *formula *is just a statement that a user makes to perform a calculation. A formula consists of a combination of values along with one or more operations, like addition, subtraction, etc.

The values used in a formula can be numeric or text values reference to cells or defined names.

A formula can be simple, as the ones are shown below, with just two variables and an operation:

= 6 - 5

= A2 – B2

It can also be complex, consisting of a series of operations.

In any case, a formula should always start with an ‘equal to’ sign (=). Whenever you use a formula in a cell, it is displayed on the *formula bar*.

When you finish entering a formula in a cell, it performs the operations as soon as you press the return key.

At this point, the result of the formula gets displayed in the cell, while the actual formula is displayed in the formula bar when the cell is selected:

To use a formula to subtract two cell values in Google Sheets, follow these steps:

- Select the cell where you want the result to appear (cell C2)
- Put an equal to sign (=) in the cell to start the formula. If you look up at the formula bar you will notice an equal to (=) sign appearing there too.
- Select the cell containing the number you want to subtract from, or the minuend(cell A2)
- Follow this with a minus sign (-).
- Select the cell containing the number you want to subtract, or the subtrahend (cell B2)
- Press the return key.
- The difference between the values in A2 and B2 should now be displayed as the result in cell C2.
- Once you get the first formula ready, getting results for the rest of the cells in the same column is easy. You will notice a small square at the bottom right corner of cell C2. This is called the
*Fill Handle*. Hover your mouse over it. - When your mouse changes into a plus sign, just double click on the square. You will find the formula copied to all the cells in column C. Alternatively, you could just drag the fill handle down the column till you reach the last row.

Each cell in column C should now contain the value of the corresponding *Expenditure*, subtracted from the *Income*!

Wasn’t that easy?

Here’s another way…

### Method 2: Subtracting in Google Sheets using the MINUS Function

A *function *is a kind of formula that has been pre-built to perform specific tasks. For example, there are functions to find sums, differences, averages, etc.

Just like formulas, functions always start with an ‘equal to’ sign (=). This is followed by the name of the function and parentheses. Inside the parentheses, you can list *parameters *(or *arguments*), if applicable.

*Arguments *are input values that the function uses to perform its task. The number and type of arguments depend on the syntax of the function. For example, Google Sheets has a function called MINUS that is used to subtract two numbers. This function’s syntax takes two parameters – the *subtrahend *and the *minuend*.

If there is more than one argument, then they are separated by commas. So the MINUS function’s syntax is as follows:

=MINUS(value1, value2)

Here:

*value1*is the subtrahend.*value2*is the minuend.

In this formula, *value1 *and *value2 *can either be numbers, dates, or references to cells containing numbers and/or dates.

So, you can write either:

=MINUS(6, 5)

*or*

=MINUS(A1 , B1)

Like formulas, whenever you use a function in a cell, it is displayed on the formula bar.

When you finish entering the function in a cell, it performs the operations as soon as you press the return key.

At this point, the result of the function gets displayed in the cell, while the actual formula is displayed in the formula bar when the cell is selected:

Here’s how you can type out a function to subtract two cell values in Google Sheets:

- Select the cell where you want the result to appear (cell C2)
- Put an equal to sign (=) in the cell to start the formula. If you look up at the formula bar you will notice an equal to (=) sign appearing there too.
- Type function name MINUS, followed by opening parentheses. Your formula bar should now show:
- Select the cell containing the number you want to subtract from, or the minuend(cell A2). This will display the cell reference of the selected cell after the opening parentheses.
- Follow this with a comma (,)
- Select the cell containing the number you want to subtract, or the subtrahend (cell B2)
- Close the parentheses. Your formula bar should now show:
- Press the return key.
- The difference between the values in A2 and B2 should now be displayed as the result in cell C2.
- Once you get the first formula ready, getting results for all the rest of the cells in the same column is easy. Hover your mouse over the
*Fill Handle*(located at the bottom left of cell C2). - When your mouse changes into a plus sign, double click on the square. You will find the formula copied to all the cells in column C. Alternatively, you could drag the fill handle down the column till you reach the last row.

Each cell in column C should now contain the value of the corresponding *Expenditure*, subtracted from the *Income*.

So this is how you can subtract numbers in Google Sheets using simple formulas.

I hope you found this article useful!

**Other Google Sheets articles you may like:**

## 1 thought on “How to Subtract in Google Sheets (2 Easy Ways)”

I found this really useful. Thank you. 🙂