In this tutorial, you will learn how to subtract in Google Sheets.
How to Subtract in Google Sheets
Subtraction is a very common task when working with spreadsheets.
For example, you may want to calculate the difference between two values or subtract a specific value from multiple cells in a certain column.
Subtraction can also be used to compute discounts and can also be used to know how far apart two dates are.
Google Sheets makes it easy to subtract values using the subtract operator and SUBTRACT function.
In this guide, we will show you how to use this function and we will also explain how to subtract arrays or ranges.
How to Find the Difference Between Values in Google Sheets
Here’s how to find the difference between values in Google Sheets.
Select the cell you want to place your subtraction formula.
In this example, we want to compute for the discounted price given the original price and discount.
Type the “=” symbol and type the reference of the cell you want to subtract from.
Type the “-” operator to indicate you want to subtract
Finally, type the amount you want to subtract from the first number.
We can also subtract two ranges of the same size. First, type the string “=ARRAYFORMULA(“ to start a new array formula.
Array formulas allow us to use arrays as input and return arrays as output.
As an argument of our array function, we can type the cell ranges we want to subtract as seen below.
This guide should be everything you need to subtract in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More basic math formulas in Google Sheets:
- AVERAGE Function
- MAX Function
- MIN Function
- FLATTEN Function
- GROWTH Function
- Transpose Data
- SORT Function
- How To Round
- How To Multiply
- How To Divide
- How To Subtract
- Round Down
- Add Cells
- Multiply Cells
- Subtract Cells
- Find Median
- Find Quartiles
- Automatically Add Numbers
- Find Mean
- Standard Deviation
- Find Average
- Find Range
- Find Variance
- T Test
- Use Pi In Google Sheets
- How To Square
- Square Root
- Sum Columns or Rows
- SUMPRODUCT Formula
- How To Create A Function
- How To Create Formula