How To Subtract On Google Sheets

How To Articles

Hey there, fellow spreadsheet enthusiasts! Today, I want to delve into the wonderful world of Google Sheets and talk about how we can subtract values using this powerful tool. Subtraction is a fundamental operation in any spreadsheet, and Google Sheets makes it super easy to perform this task efficiently.

Getting Started

Let’s start by opening up a new or existing Google Sheets document. Once you have your sheet open, navigate to the cell where you want the result to appear. This could be the cell where you want to display the result of the subtraction or a separate cell that will hold the formula.

Basic Subtraction Formula

To subtract in Google Sheets, you’ll need to use the basic subtraction formula. In the target cell, type = and then the cell containing the minuend (the value you want to subtract from) followed by a - sign and then the cell containing the subtrahend (the value you want to subtract).

For example, if you want to subtract the value in cell A2 from the value in cell B2, your formula would look like this: =B2-A2

Using Numerical Values

If you want to subtract numerical values directly without referencing cells, simply enter the values with the - operator in between. For instance, =10-5 will give you the result of 5.

Using Function for Multiple Cells

When you want to subtract values from multiple cells, you can use the =SUM function. Simply type =SUM( and then highlight the range of cells you want to subtract, separating each cell with a comma. Then close the parentheses and hit enter. For example, =SUM(A2:A5) - SUM(B2:B5) will give you the difference between the sum of values in cells A2 to A5 and the sum of values in cells B2 to B5.

Formatting and Customization

Once you’ve got your subtraction formula in place, you can customize the formatting of the cell to control how the result appears. You can change the number format, use custom number formats, or even apply conditional formatting to highlight specific results.


And that’s a wrap, folks! Subtraction in Google Sheets is a breeze once you get the hang of it. Whether you’re managing your personal finances or handling complex data analysis, the ability to subtract values is a crucial skill. So go ahead, give it a try, and unlock the full potential of your Google Sheets prowess!