The process of subtracting numbers in Google Sheets is not only basic but also crucial. In this article, we will show you exactly how to subtract in Google Sheets using the minus (-) sign and the MINUS function, along with formulas and sample examples.
Using the Minus (-) Sign in Google Sheets
The minus (-) sign in Google Sheets can be used to subtract individual numbers, but we can also use the SUM function to subtract numbers from a range. In this example, we will use a set of data to demonstrate how to perform this operation by using subtraction to find the total amount of each item. We will then apply further subtraction to a range of data.
Example 1 – Using the Minus (-) Operator in Google Sheets
- Select an empty cell within the data set to subtract.
- Enter the formula using the minus (-) sign in the empty cell.
- Formula:
=Value1 - Value2 - Value1: This is the value from which Value2 will be subtracted.
- -: The minus sign is used in Google Sheets for subtraction.
- Value2: This is the value that will be subtracted from Value1.
- Formula:
Example 2 – Using the Minus (-) Sign on a Range
- Select an empty cell within the data set where the new total will be displayed.
- Enter the formula using the SUM function.
- Formula:
=SUM(Target Range) - Value - Target Range: This is a range of cells that will be totaled in this equation.
- -: This is the operator used for subtraction.
- Value: This is the amount that will be subtracted from the target range.
- Formula:
Using the MINUS Function in Google Sheets
Google Sheets has a function specifically designed for subtraction. This function can be used for individual numbers and target cells.
The syntax for the MINUS function in Google Sheets is as follows: =MINUS(Value1, Value2)
=MINUS: This is the MINUS function in Google Sheets used to subtract the specified values.- Value1: This is the amount from which Value2 will be subtracted, and it can be a cell reference or an individual number.
- Value2: This is the amount that will be subtracted from Value1.
If you enjoyed this article, you might also like our articles on how to subtract hours in Google Sheets or how to round numbers in Google Sheets.
Visit Crawlan.com for more tips and tricks on productivity and efficiency in Google Sheets.
And don’t forget to use our insurance reminder software to easily set up customized reminders from your spreadsheet with just a few clicks.
If you’re interested in learning how to export email addresses from Google Sheets or how to multiply in Google Sheets, we also recommend checking out our detailed guide.
Remember, with the right tools and techniques, mastering Google Sheets is just a few clicks away!
