How to Subtract in Google Sheets
Use the minus operator (-) to subtract in Google Sheets. You can subtract fixed numbers, cell references, dates, times, or percentages; Google Sheets does not have a SUBTRACT function.
Reviewed by the SheetsX team
Subtracts the value in B1 from the value in A1 and returns the difference.
Subtracts Units Sold from Starting Stock to calculate Remaining Stock.
SheetsX verified four subtraction results without changing the fictional product data or headers.
What is the subtraction formula in Google Sheets?
Enter =A1-B1 in an empty cell, replacing A1 with the starting value and B1 with the value to subtract. For example, =B2-C2 subtracts Units Sold from Starting Stock. Press Enter, then drag the fill handle down to copy the formula. Google Sheets uses the minus operator; there is no SUBTRACT function.
Watch SheetsX write and verify four subtraction formulas
The Agent subtracts Units Sold from Starting Stock for four products, replaces only the incorrect Remaining Stock values, updates their fill color, and confirms that every other cell stayed unchanged.
The recording uses fictional inventory data. It shows the exact English prompt, the formulas =B2-C2 through =B5-C5, the calculated values 85, 105, 55, and 56, and the final no-other-cells-changed verification.
“Fix the incorrect Remaining Stock values in D2:D5. Replace the hardcoded zeros with these subtraction formulas and do not change any product names, starting stock, units sold, or header labels: D2 =B2-C2, D3 =B3-C3, D4 =B4-C4, D5 =B5-C5. Remove the red fill from D2:D5, use a pale green fill, and verify the displayed results are 85, 105, 55, and 56. Reply in English and confirm that no other cells changed.”
How to subtract in Google Sheets
Choose the starting value, enter the minus operator, add the value to subtract, and verify the result before copying the formula to other rows.
- 1
Select the result cell
Click the empty cell where you want the difference to appear, such as D2 for Remaining Stock.
- 2
Enter the subtraction formula
Type an equals sign, the starting cell, a minus sign, and the second cell. For example, enter =B2-C2.
- 3
Press Enter and check the result
Confirm that the displayed result matches the visible source values. In the demo, 120 minus 35 returns 85.
- 4
Copy the formula down
Drag or double-click the fill handle to copy the formula. Relative references update automatically for each row.
Subtraction formulas for common Google Sheets tasks
Use cell references when source values may change. Fixed numbers, dates, times, and percentages use the same minus operator.
| Use case | Formula or setting | What it does |
|---|---|---|
| Subtract one cell from another | =B2-C2 | Subtracts the value in C2 from B2 and updates automatically when either source cell changes. |
| Subtract fixed numbers | =120-35 | Returns 85, but fixed numbers will not respond when values elsewhere in the sheet change. |
| Subtract more than one value | =B2-C2-D2 | Subtracts C2 and then D2 from B2, evaluating the expression from left to right. |
| Calculate days between dates | =B2-A2 | When A2 and B2 contain dates, the result is the number of days between them. |
| Reduce a value by a percentage | =B2-(B2*C2) | Subtracts the percentage in C2 from the original amount in B2, such as a discount from a price. |
Ask SheetsX to write subtraction formulas and verify them
A precise Agent prompt identifies the source cells, destination range, expected results, formatting change, and cells that must remain untouched so the edit is easy to audit.
Install SheetsX- Open a new English Agent chat for a clean task context.
- Name the source columns and exact destination cells.
- Provide the subtraction formula for the first row or every required cell.
- State which source data, labels, and formatting must remain unchanged.
- Review both the formulas and displayed differences before continuing.
Google Sheets subtraction questions
How do I subtract in Google Sheets?+
Type =A1-B1 in an empty cell and press Enter. Replace A1 with the starting value and B1 with the value you want to subtract.
Is there a SUBTRACT function in Google Sheets?+
No. Google Sheets uses the minus operator (-) for subtraction. A formula such as =B2-C2 subtracts C2 from B2.
How do I subtract multiple cells in Google Sheets?+
Chain the cell references with minus operators, such as =A1-B1-C1. If you want to subtract a total range from one value, use =A1-SUM(B1:B5).
How do I subtract a percentage in Google Sheets?+
To reduce B2 by the percentage in C2, use =B2-(B2*C2) or the equivalent =B2*(1-C2). Format C2 as a percentage.
How do I subtract dates in Google Sheets?+
Use =B2-A2 when both cells contain valid dates. Google Sheets returns the elapsed number of days; format the result as a number if it displays as a date.
Why does my subtraction formula show an error?+
Check that the formula starts with =, uses a standard minus sign, and references cells containing numbers, dates, or times rather than unparseable text.