A2oz

How Do I Subtract Cells in Google Sheets?

Published in Google Sheets 1 min read

You can subtract cells in Google Sheets using the minus sign (-) operator. Simply type the minus sign between the cells you want to subtract.

Here's how to do it:

  1. Select the cell where you want to display the result of the subtraction.
  2. Type the equal sign (=) to start the formula.
  3. Click the first cell you want to subtract.
  4. Type the minus sign (-).
  5. Click the second cell you want to subtract.
  6. Press Enter to complete the formula.

Examples:

  • To subtract the value in cell A1 from the value in cell A2, you would use the formula: =A2-A1
  • To subtract the value in cell B3 from the sum of cells A1 and A2, you would use the formula: =A1+A2-B3

Practical Insights:

  • You can use cell references or specific values in your subtraction formulas.
  • You can subtract multiple cells from each other within a single formula.
  • Google Sheets automatically updates the result whenever you change the values in the cells used in the formula.

Related Articles