NorthStar Analytics

HiDocs High-Quality Ghost Documentation Theme

How to subtract in Google Sheets?

How to subtract in Google Sheets?

It's pretty easy to do the math when working in Google Sheets thanks to the 'formulas'.  There are different ways to subtract.

Subtract in Google Sheets Using the MINUS Function

What is the syntax of the MINUS function?


  1. Go to the cell where you want to have the result
  2. Write =MINUS ()
  3. Enter which cell-to-cell operation you want in parentheses.

Please be careful about:

  • Do not forget to write “=”.
  • Do not forget to put “,” between values.

We need two values ​​for subtraction.

That's it! The subtraction was done for the first row. If you want to do this for the column, you just need to pull down the small square in the lower right corner.

Pull it down to apply it to the other rows.

Pull it to the right to apply it to the other columns.

What to pay attention to here is that we applied the same formula to the cells on the others. Each time it will subtract the last result from the cell to its left.

Subtract In Google Sheets Using A Simple Formula

  1. Go to the cell where you want to have the result.
  2. Write " = “
  3. Select the first cell you want to operate and type “-“.
  4. Then select the second cell you want to process and that's it.

Please, don't forget to write “=” and do not forget to put “-” between values.

Subtraction is completed. Pull down the small square on the right to operate in the other rows.

How to Subtract Using the Menu?

You can also access the MINUS function using the menu.

Menu -> Insert ->Function ->MINUS

That's it for the collection. You can refer to these articles for other mathematical operations.

How is the collection done?->" How to add numbers in Google Sheets?"

How is multiplication done?-> "How to multiply in Google Sheets?"

Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.