To use the MINUS function in Google Sheets, click an empty cell, type =MINUS(A2, B2) and press Enter. Sheets subtracts the second value from the first and shows the difference. MINUS takes exactly two values, either typed numbers or cell references, and gives the same answer as =A2-B2. These steps cover Google Sheets in a web browser on a Windows PC, Chromebook or Mac.
What MINUS Does and the Terms You Need
MINUS is one of the operator functions in Google Sheets. Each one does the same job as a math symbol: ADD matches +, MINUS matches -, MULTIPLY matches * and DIVIDE matches /. The syntax listed on the MINUS function help page is:
MINUS(value1, value2)
A few words show up again and again in this article:
- Argument: a value you put inside the parentheses. MINUS has two, separated by a comma.
- Minuend (value1): the starting number, the one you subtract from.
- Subtrahend (value2): the number being taken away.
- Cell reference: a column letter plus a row number, such as
B2, that points to a cell instead of a fixed number. When the cell changes, the result updates.
All you need is a Google account and a spreadsheet you can edit. If you only have view or comment access, you can’t type formulas into the sheet, so make a copy first with File > Make a copy.
Subtract Two Cells With MINUS
Put the starting number in one cell and the amount to take away in another. In this example, A2 holds 250 and B2 holds 75.
- Click the empty cell where the answer should appear, such as C2.
- Type
=MINUS(. The equals sign tells Sheets that a formula follows, and a small help box with the syntax appears under the cell as you type. - Click cell A2 (or type
A2). This is the number you’re subtracting from. - Type a comma, then click cell B2 (or type
B2). This is the number being taken away. - Type the closing parenthesis so the formula reads
=MINUS(A2,B2). - Press Enter. C2 shows 175. Click C2 again and the formula appears in the formula bar above the grid.
You can also type numbers straight into the function. =MINUS(10,4) returns 6. That’s handy for a quick check, but the result never changes, so cell references are the better habit for anything you’ll update later.
Copy the Formula Down a Column
When you have many rows to subtract, write the formula once and copy it. Select C2, then drag the small blue square in its bottom-right corner down to the last row. Sheets changes the row numbers for you, so C3 becomes =MINUS(A3,B3), C4 becomes =MINUS(A4,B4) and so on. Another route is to select C2 through the last cell in the column and press Ctrl + D on Windows or ChromeOS (Command + D on a Mac), which is the fill-down shortcut listed in the Google Sheets keyboard shortcuts.
MINUS or the Minus Sign: Which Should You Use?
Both give the same answer for two values, so the choice comes down to what you’re building. The plain operator is shorter and can take away several numbers at once. MINUS is easier to spot when you scan a long formula, and some people find the named function clearer when sharing a sheet with beginners. For a broader look at subtraction formulas, the walkthrough on every way to subtract in Google Sheets covers the operator and SUM approaches in more depth.
| Task | MINUS formula | Operator formula |
|---|---|---|
| Subtract one cell from another | =MINUS(A2,B2) | =A2-B2 |
| Take three amounts from a total | =MINUS(MINUS(MINUS(A2,B2),C2),D2) | =A2-B2-C2-D2 |
| Take a whole range from a total | =MINUS(A2,SUM(B2:D2)) | =A2-SUM(B2:D2) |
| Subtract a typed number | =MINUS(A2,15) | =A2-15 |
Notice the second row. Because MINUS accepts only two arguments, chaining it gets messy fast. When you need to take several amounts away from one starting value, pair MINUS with SUM as shown in the third row, or switch to the minus sign.
Subtract Whole Columns With ARRAYFORMULA
MINUS on its own is built for single values. To subtract one column from another in a single formula, wrap it in ARRAYFORMULA, which lets functions that normally take one value work on a whole range and spreads the results down the column.
- Make sure the result column is empty from the first result cell to the bottom of your data. Anything already sitting there blocks the results.
- Click the first result cell, such as C2.
- Type
=MINUS(A2:A10,B2:B10), but don’t press Enter yet. - Press Ctrl + Shift + Enter (Command + Shift + Enter on a Mac). Sheets adds
ARRAYFORMULA(to the front, giving=ARRAYFORMULA(MINUS(A2:A10,B2:B10)). You can also type that wrapper yourself. - Press Enter. Every row from 2 to 10 gets its own difference, all from the one formula in C2.
Both ranges must be the same size. A2:A10 paired with B2:B12 won’t line up row for row. To edit or remove the results later, change or delete the formula in C2, not the cells below it. The ARRAYFORMULA help page also notes that array formulas can’t be exported, which matters if you plan to download the sheet in another format.
Using MINUS With Dates and Times
Google Sheets stores each date as a number: the DATE function page explains that Sheets counts the days since December 30, 1899. That’s why MINUS works on dates. If A2 holds 3/1/2026 and B2 holds 3/15/2026, =MINUS(B2,A2) returns 14, the number of days between them. Put the later date first to get a positive answer.
The count doesn’t include the starting day. If you’re counting days of an event that runs from the 1st through the 15th, add one: =MINUS(B2,A2)+1. For gaps in months or years, DATEDIF is a better fit, and the separate walkthrough on finding the days between two dates in Sheets goes through DAYS and DATEDIF step by step.
Times work the same way. If A2 is 9:00 AM and B2 is 5:30 PM, =MINUS(B2,A2) gives the time between them, but Sheets may show it as a clock time or a decimal. Select the cell, choose Format > Number and look for the Duration option in the list to show it as 8:30:00. To take a fixed amount off a time, use the TIME function as the second argument: =MINUS(A2,TIME(1,30,0)) subtracts 1 hour and 30 minutes. Shifts that cross midnight need extra handling, which is covered in subtracting times and hours worked in Sheets.
Worked Example: A Simple Project Budget
Say three team members each have a budget for a project, and you want to see who has money left. The data sits in columns A through C, with the formula in column D.
| A: Name | B: Budget | C: Spent | D: Remaining | |
|---|---|---|---|---|
| 2 | Alex | 1200 | 950 | =MINUS(B2,C2) returns 250 |
| 3 | Jordan | 800 | 875 | =MINUS(B3,C3) returns -75 |
| 4 | Priya | 1500 | 1320 | =MINUS(B4,C4) returns 180 |
Enter =MINUS(B2,C2) in D2 and copy it down to D4. Jordan’s row comes out negative because the spending is larger than the budget, which is exactly the signal you want. To add a total of what’s left across the team, put =SUM(D2:D4) in D5 for an answer of 355. If you’d rather fill the whole column at once, =ARRAYFORMULA(MINUS(B2:B4,C2:C4)) in D2 gives the same three results.
When MINUS Gives an Error or the Wrong Answer
Most problems come from what’s in the cells rather than the function itself. Hovering over a cell that shows an error usually brings up a short note explaining what went wrong.
- #VALUE! error: one of the cells holds a word or label instead of a number, such as “pending” or “n/a”. Replace it with a plain number.
=ISNUMBER(A2)returns TRUE when a cell holds a real number, which is a quick way to find the culprit. - #NAME? error: the function name is misspelled, as in
=MINIS(A2,B2). Check the spelling against the help box that appears as you type. - Too many arguments: typing
=MINUS(A2,B2,C2)produces an error because MINUS accepts only two values. Use=MINUS(A2,SUM(B2:C2))or=A2-B2-C2instead. - A range inside plain MINUS:
=MINUS(A2:A10,B2:B10)entered without ARRAYFORMULA won’t give you a column of answers. Add the wrapper as described above. - The sign is backwards: the order of the arguments matters.
=MINUS(4,10)is -6, while=MINUS(10,4)is 6. If you only care about the size of the gap, wrap the formula in ABS:=ABS(MINUS(A2,B2)). To flip a sign on purpose, UMINUS reverses it. - The answer looks like a date: a result such as 1/13/1900 means the cell is formatted as a date. Choose Format > Number > Number to see the plain count.
- Too many decimals or a rounded result: the cell format controls how many decimal places you see, not the stored value. Use Format > Number to pick a format, or the decimal-place buttons in the toolbar if your toolbar shows them.
Check the Result and Undo a Mistake
To confirm a MINUS result, click the cell and read the formula bar to make sure the references point at the right cells. Clicking inside the formula bar also highlights each referenced cell in color on the grid. For a quick cross-check, type =B2-C2 in a spare cell; the two answers should match. Press Ctrl + ~ to show every formula in the sheet at once, and press it again to go back to the results.
If a formula overwrote something you needed, press Ctrl + Z (Command + Z on a Mac) to undo it, and Ctrl + Y (Command + Y) to redo. To keep the answers but drop the formulas, copy the result cells and paste them back with Ctrl + Shift + V (Command + Shift + V), which pastes values only. Be careful with that step: once the formulas are gone, the numbers stop updating when the source cells change.
Other Things People Ask About MINUS
Can MINUS subtract a percentage?
Yes, as long as you work out the amount first. To take 15 percent off a price in A2, use =MINUS(A2,A2*15%). With the price at 120, the result is 102. Writing =MINUS(A2,15%) would only take away 0.15, not 15 percent of the price.
Does MINUS work with fractions?
It does. =MINUS(1/2,1/4) returns 0.25. To display the answer as a fraction rather than a decimal, set a custom number format under Format > Number > Custom number format using a pattern such as # ?/?.
Can I subtract a cell on another tab?
Yes. Put the tab name and an exclamation point before the cell: =MINUS(Sheet1!B2,Sheet2!B2). If the tab name has a space, wrap it in single quotes, as in ='Q1 Costs'!B2.
Can MINUS take away a value from many cells at once?
Yes, with ARRAYFORMULA. =ARRAYFORMULA(MINUS(A2:A10,5)) subtracts 5 from every cell in A2:A10 and lists the results down the column.
Is there a MINUS function in other spreadsheet apps?
MINUS is part of the Google Sheets operator set. In other apps the safest route is the minus sign, which works everywhere. If you also keep files in Microsoft’s spreadsheet app, the steps for subtracting cells in Excel show the formulas that carry over.
Next, try MINUS on a column of your own data, then copy it down or wrap it in ARRAYFORMULA once the first row gives the answer you expect.