How to Subtract Cells in Excel
Step 1: Type the equals sign (=)
Start your formula in the cell where you want to output the difference by typing the equals sign (=).
Type the equals sign (=)
Step 2: Click on the cell containing a number
Select the cell containing the minuend by clicking on it.
Click on the cell containing a number
Step 3: Type a minus sign (-).
Insert the negative sign (-) after the quantity you want to subtract.
Step 4: Choose the cell with the number to subtract
Click on the cell containing the number to be subtracted to include it in the calculation.
Step 5: Press the Enter to apply
Press the Enter key to complete your formula
How to Subtract in Excel – Easy Formulas
Excel is an excellent tool for accounting and numerical data processing. Subtracting two numbers is a common operation. Excel does not have a “subtract” button or function. You can use the Minus sign (-) instead. We’ll show you how to use Excel to extract numbers, cells, percentages, dates, and times.
Table of Content
- Subtract in Excel Using Subtraction Formula
- How to Subtract Cells in Excel
- How to Subtract Multiple Cells from One Cell in Excel
- How to Subtract Columns in Excel
- How to Subtract a Value from an Entire Column in Excel
- How to Subtract Percentages in Excel
- How to Subtract Dates in Excel
- How to Subtract Time in Excel
- How to do Matrix Subtraction in Excel
- How to Subtract a Text String in Excel
- Conclusion
- How to Subtract in Excel – FAQs