Subtract numbers
To subtract numbers in Excel, you simply use the minus (-) operator.
✅ Basic Syntax
=number1 - number2
📌 Examples
1. Subtract two numbers
=10 - 4
Result: 6
2. Subtract cell values
If:
- A1 = 15
- B1 = 5
Then in cell C1:
=A1 - B1
Result: 10
3. Subtract a series of values
You can subtract more than two values:
=100 - 20 - 30
Result: 50
💡 Tips
- Excel follows left-to-right order for subtraction.
- If subtracting dates (e.g.,
=EndDate - StartDate), it returns the number of days between them.