You are viewing the article How to Subtract in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 17,254 times.
This wikiHow teaches you how to do subtraction in Excel.
Steps
Subtract the value of multiple cells
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f1/Subtract-in-Excel-Step-1.jpg/v4-728px-Subtract-in-Excel-Step-1. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f1/Subtract-in-Excel-Step-1.jpg/v4-728px-Subtract-in-Excel-Step- 1.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div> “}
Open up Excel. The app is green with a white “X”.
- If you want to use an existing Excel document, double-click the Excel document to be calculated.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/56/Subtract-in-Excel-Step-2-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-2-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/56/Subtract-in-Excel-Step-2-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-2-Version-2.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Blank workbook (for regular computers) or Excel Workbook (for Macbooks) at the top left of the “Template” window to create a new workbook.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b3/Subtract-in-Excel-Step-3-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-3-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b3/Subtract-in-Excel-Step-3-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-3-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter data if necessary. To proceed, click a cell, type a number, and then press ↵ Enter or ⏎ Return .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/fb/Subtract-in-Excel-Step-4-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-4-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/fb/Subtract-in-Excel-Step-4-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-4-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Click an empty cell to select it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cf/Subtract-in-Excel-Step-5-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-5-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cf/Subtract-in-Excel-Step-5-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-5-Version-2.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:” <div class=”mw-parser-output”></div>”}
Type “=” into the cell (excluding quotes). You will always have to enter an “equal” sign before inserting any formula in Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/72/Subtract-in-Excel-Step-6-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-6-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/72/Subtract-in-Excel-Step-6-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-6-Version-2.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter a name in the box. This is the name of the cell that contains the data that you want to subtract from the value of one (or more) other cells.
- For example, type “C1” to select the number in cell C1 .
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6b/Subtract-in-Excel-Step-7-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-7-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6b/Subtract-in-Excel-Step-7-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-7-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:” <div class=”mw-parser-output”></div>”}
Type - in the box. You will see a minus sign appear after the number you entered.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7c/Subtract-in-Excel-Step-8.jpg/v4-728px-Subtract-in-Excel-Step-8. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7c/Subtract-in-Excel-Step-8.jpg/v4-728px-Subtract-in-Excel-Step- 8.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”<div class=”mw-parser-output”></div> “}
Type in another cell’s name. This is the cell whose value is used as a subtraction.
- You can repeat the process with multiple cells (eg “C1-A1-B2”).
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/61/Subtract-in-Excel-Step-9-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-9-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/61/Subtract-in-Excel-Step-9-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-9-Version-2.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:” <div class=”mw-parser-output”></div>”}
Press ↵ Enter or ⏎ Return . The formula in the cell will be calculated and replaced with the result.
- You can click on the cell to see the original formula in the text bar located just above the letter row.
Subtract within a cell
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/24/Subtract-in-Excel-Step-10-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-10-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/24/Subtract-in-Excel-Step-10-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-10-Version-2.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:” <div class=”mw-parser-output”></div>”}
Open up Excel. The app is green with a white “X”.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/da/Subtract-in-Excel-Step-11-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-11-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/da/Subtract-in-Excel-Step-11-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-11-Version-2.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Blank workbook (for regular computers) or Excel Workbook (for Macbooks) in the upper left of the “Template” window to create a new workbook.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/c1/Subtract-in-Excel-Step-12-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-12-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/c1/Subtract-in-Excel-Step-12-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-12-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:” <div class=”mw-parser-output”></div>”}
Click a cell. The cell you select doesn’t matter, unless you plan to create data in this workbook.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f2/Subtract-in-Excel-Step-13-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-13-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f2/Subtract-in-Excel-Step-13-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-13-Version-2.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:542,”licensing”:” <div class=”mw-parser-output”></div>”}
Type “=” (excluding quotes) in the box. You will always have to enter an “equal” sign before inserting any formula in Excel.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/1/11/Subtract-in-Excel-Step-14-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-14-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/1/11/Subtract-in-Excel-Step-14-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-14-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:” <div class=”mw-parser-output”></div>”}
Type the number you want to subtract (the number to be subtracted). The number will appear in the selected cell, just to the right of the “equal” sign.
- For example, to calculate a budget, you need to enter your income for the month in this box.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b8/Subtract-in-Excel-Step-15-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-15-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b8/Subtract-in-Excel-Step-15-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-15-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:” <div class=”mw-parser-output”></div>”}
Type - in the box. You will see a minus sign appear after the number you entered.
- If you want to subtract multiple numbers (for example, XYZ), you’ll have to repeat this step after each subsequent number, minus the last one.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/3/31/Subtract-in-Excel-Step-16-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-16-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/3/31/Subtract-in-Excel-Step-16-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-16-Version-2.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter the minus number.
- If you’re budgeting, you’ll need to enter the amount spent in this box.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/89/Subtract-in-Excel-Step-17-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-17-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/89/Subtract-in-Excel-Step-17-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-17-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:” <div class=”mw-parser-output”></div>”}
Press ↵ Enter or ⏎ Return . The formula in the cell will be calculated and replaced with the result.
- You can click on the cell to see the original formula in the text bar located just above the letter row.
Subtract within a column
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2e/Subtract-in-Excel-Step-18-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-18-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2e/Subtract-in-Excel-Step-18-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-18-Version-2.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:” <div class=”mw-parser-output”></div>”}
Open up Excel. The app is green with a white “X”.
- If you want to use an existing Excel document, double-click the Excel document to be calculated.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6f/Subtract-in-Excel-Step-19-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-19-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6f/Subtract-in-Excel-Step-19-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-19-Version-2.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:” <div class=”mw-parser-output”></div>”}
Click Blank workbook (for regular computers) or Excel Workbook (for Macbooks) in the upper left of the “Template” window to create a new workbook.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Subtract-in-Excel-Step-20-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-20-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Subtract-in-Excel-Step-20-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-20-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:” <div class=”mw-parser-output”></div>”}
Click an empty cell to select it.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/f/f7/Subtract-in-Excel-Step-21-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-21-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/f/f7/Subtract-in-Excel-Step-21-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-21-Version-2.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter the main number. Counting from the cell containing this number, the rest in the column will be selected.
- For example, you can enter your salary for the year here.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/ab/Subtract-in-Excel-Step-22-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-22-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/ab/Subtract-in-Excel-Step-22-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-22-Version-2.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:” <div class=”mw-parser-output”></div>”}
Enter any subtraction in the box below. Enter the negative number of the number you want to subtract (for example, if you want to subtract 300, type “-300”).
- Enter a subtraction in each cell.
- Make sure that each number you enter is in the same column as the main number
- For payroll calculations, you need to type a “-” sign before each expense in each cell.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b5/Subtract-in-Excel-Step-23-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-23-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b5/Subtract-in-Excel-Step-23-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-23-Version-2.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:” <div class=”mw-parser-output”></div>”}
Click an empty cell. This cell does not need to be in the same column as the main number.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/2/2d/Subtract-in-Excel-Step-24-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-24-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/2/2d/Subtract-in-Excel-Step-24-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-24-Version-2.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:” <div class=”mw-parser-output”></div>”}
Type “=” (excluding quotes) to set the formula for that cell.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9e/Subtract-in-Excel-Step-25-Version-2.jpg/v4-728px-Subtract-in-Excel- Step-25-Version-2.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9e/Subtract-in-Excel-Step-25-Version-2.jpg/ v4-728px-Subtract-in-Excel-Step-25-Version-2.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:” <div class=”mw-parser-output”></div>”}
Type SUM in the cell. The “SUM” command adds the items together.
- In Excel there is no formal “subtract” command by column, that’s why we need to enter numbers as negative numbers as above.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/94/Subtract-in-Excel-Step-26.jpg/v4-728px-Subtract-in-Excel-Step-26. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/94/Subtract-in-Excel-Step-26.jpg/v4-728px-Subtract-in-Excel-Step- 26.jpg”,”smallWidth”:460,”smallHeight”:342,”bigWidth”:728,”bigHeight”:541,”licensing”:”<div class=”mw-parser-output”></div> “}
Type (cell name:cell name) followed by SUM . The command will add all cells in the column from the value of the first cell to the value of the last cell.
- For example, if cell K1 is the cell containing the main number, and the last data cell in the column is K10 , type “(K1:K10)”.
{“smallUrl”:”https://www.wikihow.com/images_en/thumb/e/e3/Subtract-in-Excel-Step-27.jpg/v4-728px-Subtract-in-Excel-Step-27. jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/e/e3/Subtract-in-Excel-Step-27.jpg/v4-728px-Subtract-in-Excel-Step- 27.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”<div class=”mw-parser-output”></div> “}
Press ↵ Enter or ⏎ Return . The formula will work and output the final result in the cell you selected.
Advice
- You can also use Excel to add multiple numbers together.
Warning
- If you do not type the = sign in the cell before entering the formula, the calculation will not take place.
X
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 17,254 times.
This wikiHow teaches you how to do subtraction in Excel.
Thank you for reading this post How to Subtract in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: