✦Template Printable Ideas Insights

Mastering Google Sheets: The Minus Formula Unveiled

By

Ever found yourself needing to subtract numbers in Google Sheets, only to realize the platform doesn't have a simple minus sign as you expected? Don't worry, you're not alone. While Google Sheets doesn't use the minus (-) symbol for subtraction, it's not difficult to perform this operation. Here's a step-by-step guide on how to do a minus formula in Google Sheets.

Before we dive in, let's familiarize ourselves with the basics. In Google Sheets, operations are performed using formulas. Formulas start with an equals sign (=) and are entered in cells where you want the result to appear. The values or references you perform operations on are called operands.

The Basic Minus Operation

Google Sheets uses the hyphen (-) or the MINUS function to perform subtraction. The syntax is simple: equals sign (=), followed by the operand, the subtraction symbol, and the value to subtract.

6 Crazy Google Sheets Formulas You Should Know
6 Crazy Google Sheets Formulas You Should Know
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
The Ultimate Google Sheets Keyboard Shortcut Cheat Sheet for Beginners & Pros
How to Show Formulas in Google Sheets
How to Show Formulas in Google Sheets

For example, if you want to subtract 100 from cell A1, you would input the following formula in a cell where you want the result: =A1-100.

Auto Fill or Drag to Apply the Formula

One of the conveniences of Google Sheets is the ability to apply a formula to multiple cells with ease. After entering your formula into a cell, you can simply "drag" the small square in the bottom right corner of the cell to apply the formula to the adjacent cells. Alternatively, you can use the 'Auto Fill' option to apply the formula across cells.

Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square
Math in Google Sheets: Add, Sum, Subtract, Multiply, Divide, Square
10 Essential Google Sheets Formulas Everyone Should Know
10 Essential Google Sheets Formulas Everyone Should Know
100+ Functions & formulas for Google Sheets & Excel basics - Sheetgo
100+ Functions & formulas for Google Sheets & Excel basics - Sheetgo

For instance, if you want to subtract 100 from the values in cells B1 to B10, you can apply the formula in cell B1 (=A1-100) and then drag it down to cell B10.

Subtracting Two Cells or Ranges

You can also subtract the values of two cells or ranges directly. For this, you'll need to reference the cells inside the formula. Suppose you want to subtract the values in cell B1 from those in cell A1, you would input: =A1-B1. This will subtract the value in B1 from the value in A1.

Similarly, if you want to subtract the range of cells C1:C10 from the range A1:A10, you would use: =SUM(A1:A10)-SUM(C1:C10). The SUM function is used to add up the values in a range, which then allows you to subtract one range from another.

Basic Formatting in Google Sheets
Basic Formatting in Google Sheets
Do you think Grand Sum using ArrayFormula in Google Sheets is the right way to do it?
Do you think Grand Sum using ArrayFormula in Google Sheets is the right way to do it?
How to use OR Formula in Google Sheets with examples.
How to use OR Formula in Google Sheets with examples.
How to add Formula in Google Sheet : Google Sheet Tutorial
How to add Formula in Google Sheet : Google Sheet Tutorial
The Ultimate Google Sheets Formulas Cheat Sheet
The Ultimate Google Sheets Formulas Cheat Sheet
SUMIF in Google Sheets with formula examples
SUMIF in Google Sheets with formula examples

Using the MINUS Function

In some cases, you might find it easier to use the MINUS function instead of the hyphen (-) for subtraction. The syntax for MINUS is =MINUS(number1, number2), where number1 is the value you're subtracting from, and number2 is the value you're subtracting.

For example, to subtract 5 from 10, you would input =MINUS(10,5). The result would be 5.

MINUS Function for Multiple Values

The MINUS function can subtract multiple values at once. For this, you will need to use '(', ')', and ',' to separate the values. For instance, the formula =MINUS(10,5)-(8,3) subtracts 5 from 10 and then subtracts 3 from the result of the first operation.

Calculate Mileage Reimbursement in Google Sheets: Fast, Easy & Accurate Formula Tutorial
Calculate Mileage Reimbursement in Google Sheets: Fast, Easy & Accurate Formula Tutorial
Google Sheets: Creating Complex Formulas
Google Sheets: Creating Complex Formulas
the google sheets has hidden gems you're not using on your webpages
the google sheets has hidden gems you're not using on your webpages

It's essential to note that Google Sheets follows the order of operations (PEMDAS/BODMAS), so ensure you use parentheses correctly if you have complex calculations.

MINUS Function with Cells or Ranges

Like with the hyphen (-), you can use the MINUS function to subtract the values of cells or ranges. For instance, to subtract the values in cell B1 from those in cell A1, you would input: =MINUS(A1,B1).

Remember, the values in B1 are subtracted from the values in A1. If you want to subtract B1 from A1, you can use extrapolation: =MINUS(A1,B1)-2*B1. This subtracts B1 from A1 twice, effectively adding the value of B1 back to the result.

Like any powerful tool, Google Sheets takes a bit of getting used to. But with practice, you'll find subtracting values is a breeze. So, embrace the hyphens and MINUS functions, and keep your Google Sheets calculations accurate and efficient.