To subtract in Numbers on a Mac, click an empty cell, type an equal sign, click the cell you want to start with, type a hyphen (the minus sign), click the cell you want to take away, and press Return. A formula such as =B2-C2 shows the difference right in the cell. Numbers has no separate subtract button or MINUS function, so the minus operator does all the work. These steps cover the current version of Numbers for macOS.
Before you start: a few terms
You only need Numbers open with a spreadsheet that has at least two numbers in it. A few words come up again and again below:
- Cell reference: the column letter plus row number that names a cell, such as
B2(column B, row 2). Using references instead of typed numbers means the answer updates when the numbers change. - Formula Editor: the small floating box that opens when you type
=in a cell. It is where you build the formula. You can drag its left side to move it out of the way. - Minuend and subtrahend: the number you start with and the number you take away. In
=B2-C2, B2 is the starting value and C2 is the amount removed. The order matters:=C2-B2gives the same size answer with the opposite sign.
Subtract one cell from another
This is the method most people need: one value minus another, with the answer in a third cell.
- Open your spreadsheet in Numbers and click the empty cell where the answer should appear.
- Type
=. The Formula Editor opens over the cell, and the Functions Browser may appear on the right side of the window. You can ignore the browser for basic subtraction. - Click the cell that holds the starting number. Its reference appears in the Formula Editor as a colored token.
- Type
-(the hyphen key next to 0 on the keyboard). If you skip this and click a second cell, Numbers inserts a plus sign between the two references by default, which would add instead of subtract. - Click the cell that holds the number you want to take away.
- Press Return (or Tab), or click the Commit Formula button in the Formula Editor. The cell now shows the difference. To back out without saving, press Esc.
Apple’s own walkthrough of these controls is on the Numbers User Guide page for calculating values in table cells.
Other ways to subtract in Numbers
Pick the section that matches what you are trying to do. Each one still uses the same minus operator.
Use a blank cell like a calculator
For a quick one-off answer, click a blank cell, type =250-75, and press Return. The cell shows 175. Parentheses work too, so =(250-75)-(40-15) returns 150. You can also mix a typed number with a cell, as in =B2-20. Typed numbers never change on their own, so use cell references for anything you will update later.
Take several values away at once
Chain extra minus signs for a short list: =B2-C2-D2-E2. For a longer run of cells, total them with SUM and subtract that total in one step:
=B2-SUM(C2:H2)
The colon marks a range, so C2:H2 means every cell from C2 through H2. SUM only accepts numeric values, so a stray word in that range will cause an error.
Copy the formula down a whole column
Once the first row works, you do not have to retype it for every row.
- Click the cell that contains your subtraction formula.
- Hover over the border of the selection until a yellow dot (the autofill handle) appears.
- Drag the dot down over the rows that need the same calculation, then let go.
Each copied formula shifts to its own row, so row 3 becomes =B3-C3, row 4 becomes =B4-C4, and so on. Autofill overwrites anything already in the cells you drag across, so check that the target cells are empty first. If you prefer the keyboard, select the formula cell, press Command-Backslash (\), use the arrow keys to stretch the yellow border, and press Return. The menu route is Table > Autofill Cells. Details are in Apple’s guide to autofilling cells in Numbers.
Subtract the same number from every row
Say a flat fee sits in cell F1 and you want to take it off every amount in column B. If you write =B2-F1 and fill it down, the F1 reference slides to F2, F3 and so on, which are empty. Lock it first:
- Double-click the cell with the formula to open the Formula Editor.
- Click the small triangle on the F1 token.
- Select Preserve Row and Preserve Column.
- Press Return, then autofill the formula down the column. Every row now subtracts the same F1 value.
Subtract a value from another table or sheet
Numbers spreadsheets often hold several tables. While the Formula Editor is open, you can click a cell in a different table and Numbers adds the table name for you, producing something like =B2-Table 2::B2. The double colon separates the table name from the cell. For a cell on another sheet, the reference includes the sheet name as well, such as Sheet 2::Table 1::C2.
Find the days between two dates
When the cells hold dates and you want a plain count of days, the DAYS function is the clearest choice. The later date goes first: DAYS(end-date, start-date). For example, =DAYS("12/31/2025","1/1/2025") returns 364, and swapping the two dates returns -364. With dates in cells, write =DAYS(C2,B2). For months or years between dates, Numbers also offers DATEDIF. See the DAYS function reference for the full syntax.
Worked example: what is left of each budget
Here is a small table of made-up monthly budgets. Column B is the budget, column C is what was spent, and column D shows what remains.
| Row | A: Name | B: Budget | C: Spent | D: Remaining (formula) | Result |
|---|---|---|---|---|---|
| 2 | Alex | 500 | 420 | =B2-C2 | 80 |
| 3 | Jordan | 350 | 390 | =B3-C3 | -40 |
| 4 | Priya | 600 | 455 | =B4-C4 | 145 |
| 5 | Total | 1450 | 1265 | =SUM(D2:D4) | 185 |
To build it, type the names and amounts in columns A through C, enter =B2-C2 in D2 using the steps above, then drag the yellow autofill dot down to D4. Jordan’s -40 is correct: spending was higher than the budget. Add the total in D5 with SUM. As a cross-check, =B5-C5 (1450 minus 1265) also gives 185, which confirms the row formulas agree with the column totals.
When the answer looks wrong
Most subtraction problems in Numbers come from one of these causes.
- A red triangle in the cell. That marks a formula error, often an incomplete formula or a reference to a cell that no longer exists. Click the triangle to read the message. A blue triangle in the upper-left corner is a warning rather than an error, and clicking it explains the concern.
- Text where a number should be. Arithmetic operators return an error when one side is a word such as “n/a”. Replace the text with a number, or put 0 in the cell if nothing was spent.
- The answer has the wrong sign. The two references are probably in reverse order. Edit the formula so the starting value comes first.
- The sum doubled instead of subtracting. If you clicked two cells in a row without typing the minus sign, Numbers put a plus sign between them. Open the formula and replace the + with -.
- The result seems off by a few cents. The Decimals setting rounds what you see, not the stored value. Increase the decimals or clear the field so it reads Auto to see the full number.
- A circular reference. A formula cannot include its own cell. Writing
=D2-C2inside D2, or including D2 in a range it totals, produces an error. - New rows are missing from the result. After inserting rows or columns, recheck that range references still cover the right cells.
- No subtract option in the bar at the bottom. When you select a range, Numbers shows quick calculations such as sum, average, minimum and maximum at the bottom of the window. Subtraction is not one of them, so type a formula instead.
Check the result and fix mistakes
Double-click the formula cell and look at the Smart Cell View at the bottom of the window. While you edit a formula, it shows the result along with the values behind each reference, plus any errors or warnings. That makes it easy to spot a formula pointing at the wrong row.
To change a formula, double-click its cell. In the Formula Editor, select a reference token and click a different cell to swap it, or select it and press Delete to remove it. Press Return to save or Esc to discard the edit.
If something goes badly, press Command-Z to undo (Shift-Command-Z redoes). To keep the answers but drop the formulas, for example before sending figures to someone, copy the cells with Command-C and paste with Shift-Command-V, which pastes the formula results instead of the formulas.
Other questions about subtracting in Numbers
Is there a MINUS or SUBTRACT function?
No. Apple’s list of Numbers functions has neither. The hyphen operator handles subtraction, and SUM covers the case where you want to take away a group of cells.
How do I get the difference without a negative sign?
Wrap the subtraction in ABS, which returns the absolute value: =ABS(B3-C3) shows 40 for Jordan’s row instead of -40. This is handy when you only care how far apart two numbers are, not which is bigger.
Can negative results show in parentheses or another style?
Yes. Select the cells, open the Format sidebar, click the Cell tab, and choose Number from the Data Format pop-up menu. A pop-up menu to the right of the Decimals field sets how negative values look. With the Currency format, the Accounting Style checkbox puts negatives in parentheses. Apple covers every option on its cell formatting page for Numbers.
Is the formula the same as in Excel or Google Sheets?
The basic form, an equal sign, a cell, a hyphen and another cell, works the same way in all three apps. The interfaces differ, though, so if you share files or switch apps, the walkthroughs for subtracting cells in Microsoft Excel and writing a minus formula in Google Sheets show where things live in each one.
What if I just need one quick answer?
Typing =250-75 in a spare cell works, but if you have no spreadsheet open, the built-in app is faster. Here is how to subtract with the Mac Calculator app.
Next step: build the first formula in your own table with the six steps above, check it in the Smart Cell View, then autofill it down the column.