To subtract in a Word table, click the cell that should hold the answer, open the Table Layout tab (called Layout in some versions), select Formula in the Data group, replace the suggested formula with something like =B2-C2, and click OK. These steps apply to the Word desktop app in Microsoft 365, Word 2024, 2021, 2019 and 2016, on Windows and Mac.
Before You Start: How Word Names Table Cells
Word has no SUBTRACT function. You subtract with the minus operator (-), and you point at cells by their address. An address is a column letter plus a row number: columns run A, B, C from left to right, and rows run 1, 2, 3 from the top. So the cell in the second column of the third row is B3. If your table has a header row, that header is row 1.
The result Word inserts is a field, a small piece of code that displays a calculated value. Fields do not recalculate on their own while you type, which matters later. You also need the desktop app: field insertion and editing are fully supported only in desktop Word, so a document opened in Word for the web can show results but is not the place to build formulas.
Subtract Two Cells With the Formula Dialog Box
- Click inside the empty cell where the difference should appear. If the cell already has text, delete it first.
- Go to the Table Layout tab on the ribbon. It only appears while your cursor is in a table.
- In the Data group, select Formula. The Formula dialog box opens.
- Look at the Formula box. Word often prefills
=SUM(LEFT)or=SUM(ABOVE), which adds numbers instead of subtracting them. Delete everything except the equal sign. - Type your subtraction, for example
=B2-C2to take the value in C2 away from the value in B2. - Optionally, pick a style from the Number format list, such as
#,##0.00for two decimal places. - Click OK. The cell now shows the answer, not the formula.
You can subtract more than one cell in a single formula. =B2-C2-D2 works, and so does =B2-SUM(C2:D2), where the colon marks a range of cells. To subtract a fixed amount, type the number directly: =B2-25.
Faster Option: Type the Field Yourself
If you are comfortable with field codes, you can skip the dialog box on Windows. Click the result cell, press Ctrl+F9 to insert a pair of field braces, type =B2-C2 between them, then press F9 to show the result. Do not type the braces with the keyboard; Word only treats them as a field when it inserts them. For most people the Formula dialog box is the safer choice because it builds the field correctly every time.
Worked Example: Remaining Budget per Person
Here is a fictional team budget. Row 1 holds the headers, so the data starts in row 2. Each cell in column D gets its own formula.
| Name (A) | Budget (B) | Spent (C) | Remaining (D) |
|---|---|---|---|
| Alex | 500 | 320 | =B2-C2 shows 180 |
| Jordan | 450 | 475 | =B3-C3 shows -25 |
| Priya | 600 | 410 | =B4-C4 shows 190 |
Notice that every row needs a different formula. Word cell references are always absolute, so copying the D2 result into D3 still calculates B2-C2 and shows 180 again. After pasting, press Alt+F9 to reveal the field codes, change the row numbers, press Alt+F9 again, then select the table and press F9.
Common Problems and How to Fix Them
The answer did not change after I edited a number
Formulas calculate when you insert them and when the document opens, not as you type. Select the whole table and press F9 to refresh every formula in it. To refresh all fields in the document, press Ctrl+A and then F9.
The cell added the numbers instead
You probably kept Word’s suggested =SUM(LEFT). Reveal the code with Alt+F9, replace it with a minus formula, and update it.
I got an error or an unexpected number
Check that the address points at the right cell, counting the header as row 1. It is safest to keep the referenced cells to plain numbers, with no words or notes mixed in. If a calculation includes empty cells, type 0 in them, because blank cells can trigger an error.
The result is negative
A negative answer, like Jordan’s -25, simply means the second value was larger. If you only want the size of the gap, wrap the formula in ABS: =ABS(B3-C3) returns 25. To show negatives in parentheses, type a format with separate positive and negative parts in the Number format box, such as #,##0;(#,##0).
Check the Formula and Undo Mistakes
To see what a result cell is calculating, press Alt+F9 on Windows or fn+Option+F9 on a Mac. Every field in the document switches to its code, such as { =B2-C2 }. Press the same keys to switch back. Do a quick mental check on one row before trusting the rest.
To undo a formula you just inserted, press Ctrl+Z (Command+Z on a Mac). To remove one later, select the result in the cell and press Delete. If you want the number to stay fixed and never recalculate, on Windows click the field and press Ctrl+F11 to lock it; Ctrl+Shift+F11 unlocks it.
Questions People Ask About Word Table Math
Can I subtract a value from a whole column at once?
Not with one formula. Each result cell needs its own field. Positional words like ABOVE and LEFT only work with functions such as SUM, AVERAGE, MIN, MAX, COUNT and PRODUCT, and they skip header rows, so they cannot express “this row minus that row.” If you need hundreds of rows, a spreadsheet handles this better; see subtracting one column from another in Excel.
Can I use R1C1 style addresses?
Yes. =R2C2-R2C3 means row 2, column 2 minus row 2, column 3, which is the same as =B2-C2. The full list of reference styles and functions is on the Use a formula in a Word table support page, and the operators and number formats are covered on the = (Formula) field reference.
Can I subtract using a cell in a different table?
Yes, if you bookmark that table first. A formula can then refer to the bookmark name followed by a range, for example =B2-SUM(Table2 C:C) subtracts the total of column C in the bookmarked table from B2 in the current one.
When should I use Excel instead?
Word suits small tables in reports and invoices. Once you need formulas that fill down automatically, dates, or live recalculation, build the table in a spreadsheet. The basics of subtraction formulas in Excel and minus formulas in Google Sheets use the same =B2-C2 pattern you just learned.
Next step: open a document with a numeric table, add one subtraction formula to the first data row, and practice refreshing it with F9 after changing a number.