Home
Tutorials

How to Subtract in Google Sheets

Marty Youssef
Last updated on
December 27, 2023

Google Sheets is a powerful tool for managing data, performing calculations, and creating dynamic spreadsheets. One of the basic yet essential operations in Google Sheets is subtraction. Whether you are dealing with financial data, student grades, or any other numerical data, knowing how to subtract in Google Sheets can be incredibly useful.

This tutorial will guide you through two primary methods of performing subtraction in Google Sheets: using the minus sign and using the MINUS function.

How to Subtract in Google Sheets Using the Minus Sign

The most straightforward way to subtract numbers in Google Sheets is by using the minus sign (-). This method is similar to how you would perform subtraction in traditional mathematics.

Step-by-Step Instructions:

  1. Select the Cell for the Result: Click on the cell where you want the result of the subtraction to appear.
  2. Enter the Formula: Type = followed by the numbers or cell references you want to subtract, separated by the minus sign. For example, if you want to subtract 5 from 10, you would type =10-5.
  3. Press Enter: After typing the formula, press Enter. Google Sheets will calculate the result and display it in the selected cell.

Example:

  • If you have the number 10 in cell A1 and 5 in cell B1, and you want to find the difference, you would select cell C1, type =A1-B1, and press Enter. Cell C1 will display the result 5.
How to Subtract in Google Sheets Using the Minus Sign

Tips:

  • You can subtract multiple numbers by continuing to add the minus sign and additional numbers or cell references. For example, =A1-B1-C1-D1.
  • Remember that the order in subtraction matters. Ensure you are subtracting in the correct order to get the desired result.

How to Subtract in Google Sheets using the MINUS Function

Another way to perform subtraction in Google Sheets is by using the MINUS function. This function is specifically designed for subtraction and can be more intuitive, especially for those who are new to spreadsheet calculations.

Step-by-Step Instructions:

  1. Select the Cell for the Result: Click on the cell where you want the result of the subtraction to appear.
  2. Enter the MINUS Function: Type =MINUS(, followed by the two values or cell references you want to subtract. Close the function with a parenthesis. For example, =MINUS(A1, B1).
  3. Press Enter: Press Enter after typing the function. Google Sheets will perform the subtraction and display the result in the selected cell.

Example:

  • If cell A1 contains the number 10 and cell B1 contains 5, and you want to find the difference, you would select cell C1, type =MINUS(A1, B1), and press Enter. Cell C1 will display the result 5.
How to Subtract in Google Sheets using the MINUS Function

Tips:

  • The MINUS function only subtracts two values at a time. If you need to subtract more than two numbers, you might want to use the minus sign method or chain multiple MINUS functions together.
  • Ensure you place the number you are subtracting from first and the number you are subtracting second. For instance, =MINUS(10, 5) returns 5, but =MINUS(5, 10) returns -5.

Conclusion

Subtracting in Google Sheets is a fundamental skill that can enhance your data management and analysis capabilities. Whether you prefer the simplicity of the minus sign or the clarity of the MINUS function, both methods are effective for performing subtraction operations. By following the steps outlined in this tutorial, you'll be able to quickly and accurately perform subtraction tasks in your Google Sheets, making your data analysis more efficient and precise. Remember to practice these methods to become more proficient in managing your spreadsheets.

Marty Youssef
Marty is a digital marketer with over 8 years working with clients to introduce word class software solutions for their business.