igforum.bio / how-to-subtract-two-or-more-numbers-in-excel - 114890
D
%Start How to Subtract Two or More Numbers in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps &gt; MS Office 42 42 people found this article helpful <h1> How to Subtract Two or More Numbers in Excel</h1> <h2> Here&#39;s a simple guide to subtract two or more numbers in Excel</h2> By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on August 8, 2020 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook <h3> What to Know</h3> The basic subtraction formula is &#61;(cell location) - (cell location).The subtraction sign is denoted by the dash ( - ).More complicated problems need a good understanding of how Excel handles order of operations.
David Cohen Member
access_time 2 minutes ago
%Start How to Subtract Two or More Numbers in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! Search Close GO Software & Apps > MS Office 42 42 people found this article helpful

How to Subtract Two or More Numbers in Excel

Here's a simple guide to subtract two or more numbers in Excel

By Ted French Ted French Writer Former Lifewire writer Ted French is a Microsoft Certified Professional who teaches and writes about spreadsheets and spreadsheet programs. lifewire's editorial guidelines Updated on August 8, 2020 Tweet Share Email Tweet Share Email MS Office Excel Word Powerpoint Outlook

What to Know

The basic subtraction formula is =(cell location) - (cell location).The subtraction sign is denoted by the dash ( - ).More complicated problems need a good understanding of how Excel handles order of operations.
thumb_up Like (28)
comment Reply (0)
share Share
visibility 516 views
thumb_up 28 likes
V
This article covers how to handle simple and complicated subtraction formulas in Excel. The instructions in this article apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel for Mac, and Excel Online. <h2> Understand Excel Formulas </h2> To subtract two or more numbers in Excel, create a formula.
Victoria Lopez Member
access_time 10 minutes ago
This article covers how to handle simple and complicated subtraction formulas in Excel. The instructions in this article apply to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel for Mac, and Excel Online.

Understand Excel Formulas

To subtract two or more numbers in Excel, create a formula.
thumb_up Like (9)
comment Reply (3)
thumb_up 9 likes
comment 3 replies
A
Amelia Singh 6 minutes ago
The important points to remember about Excel formulas include: Formulas in Excel always begin with t...
L
Lucas Martinez 1 minutes ago
The formula is completed by pressing the Enter key.

Use Cell References in Formulas

Altho...
Show 1 more replies
I
The important points to remember about Excel formulas include: Formulas in Excel always begin with the equal sign ( = ). The formula is always typed into the cell where you want the answer to appear. The subtraction sign in Excel is the dash ( - ).
Isabella Johnson Member
access_time 6 minutes ago
The important points to remember about Excel formulas include: Formulas in Excel always begin with the equal sign ( = ). The formula is always typed into the cell where you want the answer to appear. The subtraction sign in Excel is the dash ( - ).
thumb_up Like (2)
comment Reply (2)
thumb_up 2 likes
comment 2 replies
C
Chloe Santos 1 minutes ago
The formula is completed by pressing the Enter key.

Use Cell References in Formulas

Altho...
D
David Cohen 4 minutes ago
This way, you won't have to rewrite the entire formula. The results of the formula update automatica...
S
The formula is completed by pressing the Enter key. <h2> Use Cell References in Formulas </h2> Although it's possible to enter numbers directly into a formula (as shown in row 2 of the example below), it's usually better to enter the data into worksheet cells and then use the addresses or references of those cells in the formula (see row 3 of the example). When cell references are used instead of the actual data in a formula, the data in the formula can be changed later by replacing the data in the cells.
Sophia Chen Member
access_time 8 minutes ago
The formula is completed by pressing the Enter key.

Use Cell References in Formulas

Although it's possible to enter numbers directly into a formula (as shown in row 2 of the example below), it's usually better to enter the data into worksheet cells and then use the addresses or references of those cells in the formula (see row 3 of the example). When cell references are used instead of the actual data in a formula, the data in the formula can be changed later by replacing the data in the cells.
thumb_up Like (33)
comment Reply (2)
thumb_up 33 likes
comment 2 replies
M
Madison Singh 8 minutes ago
This way, you won't have to rewrite the entire formula. The results of the formula update automatica...
J
James Smith 7 minutes ago

Subtraction Formula Example

As shown in the example, the formula in cell D3 subtracts the...
S
This way, you won't have to rewrite the entire formula. The results of the formula update automatically when the cell data changes. Another option is to mix cell references and actual data (see row 4 of the example below).
Sebastian Silva Member
access_time 15 minutes ago
This way, you won't have to rewrite the entire formula. The results of the formula update automatically when the cell data changes. Another option is to mix cell references and actual data (see row 4 of the example below).
thumb_up Like (14)
comment Reply (3)
thumb_up 14 likes
comment 3 replies
N
Nathan Chen 4 minutes ago

Subtraction Formula Example

As shown in the example, the formula in cell D3 subtracts the...
C
Christopher Lee 13 minutes ago

Point and Click on Cell References

It is possible to type the formula into cell D3 and ha...
Show 1 more replies
C
<h2> Subtraction Formula Example </h2> As shown in the example, the formula in cell D3 subtracts the data in cell B3 from the data in cell A3. The finished formula in cell D3 is: &#61;A3-B3<br /> The result when you press Enter is 5, which is the result of 10 - 5.
Chloe Santos Moderator
access_time 12 minutes ago

Subtraction Formula Example

As shown in the example, the formula in cell D3 subtracts the data in cell B3 from the data in cell A3. The finished formula in cell D3 is: =A3-B3
The result when you press Enter is 5, which is the result of 10 - 5.
thumb_up Like (4)
comment Reply (3)
thumb_up 4 likes
comment 3 replies
O
Oliver Taylor 8 minutes ago

Point and Click on Cell References

It is possible to type the formula into cell D3 and ha...
N
Natalie Lopez 10 minutes ago
Point and click involves selecting the cells containing the data with the mouse pointer while you&#...
Show 1 more replies
A
<h2> Point and Click on Cell References </h2> It is possible to type the formula into cell D3 and have the correct answer appear. But, when you use point and click&nbsp;to add cell references to formulas, you'll minimize the possibility of errors that happen when the wrong cell reference is typed.
Aria Nguyen Member
access_time 14 minutes ago

Point and Click on Cell References

It is possible to type the formula into cell D3 and have the correct answer appear. But, when you use point and click to add cell references to formulas, you'll minimize the possibility of errors that happen when the wrong cell reference is typed.
thumb_up Like (24)
comment Reply (1)
thumb_up 24 likes
comment 1 replies
O
Oliver Taylor 11 minutes ago
Point and click involves selecting the cells containing the data with the mouse pointer while you&#...
A
Point and click involves selecting the cells containing the data with the mouse pointer while you&#39;re typing the formula. When you select a cell, that cell reference is added to the formula. Type the equal sign ( &#61; ) into cell D3 to begin the formula.
Amelia Singh Moderator
access_time 40 minutes ago
Point and click involves selecting the cells containing the data with the mouse pointer while you're typing the formula. When you select a cell, that cell reference is added to the formula. Type the equal sign ( = ) into cell D3 to begin the formula.
thumb_up Like (37)
comment Reply (3)
thumb_up 37 likes
comment 3 replies
A
Aria Nguyen 11 minutes ago
Select cell A3 with the mouse pointer to add that cell reference to the formula. The cell reference ...
L
Luna Park 19 minutes ago
Select cell B3 to add that cell reference to the formula. The cell reference appears after the minu...
Show 1 more replies
W
Select cell A3 with the mouse pointer to add that cell reference to the formula. The cell reference appears after the equal sign. Type a minus sign ( - ) after the cell reference.
William Brown Member
access_time 27 minutes ago
Select cell A3 with the mouse pointer to add that cell reference to the formula. The cell reference appears after the equal sign. Type a minus sign ( - ) after the cell reference.
thumb_up Like (15)
comment Reply (2)
thumb_up 15 likes
comment 2 replies
A
Ava White 24 minutes ago
Select cell B3 to add that cell reference to the formula. The cell reference appears after the minu...
E
Emma Wilson 1 minutes ago
Press the Enter key to complete the formula. The answer 5 appears in cell D3. Even though the answer...
A
Select cell B3 to add that cell reference to the formula. The cell reference appears after the minus sign.
Amelia Singh Moderator
access_time 30 minutes ago
Select cell B3 to add that cell reference to the formula. The cell reference appears after the minus sign.
thumb_up Like (47)
comment Reply (2)
thumb_up 47 likes
comment 2 replies
J
Joseph Kim 7 minutes ago
Press the Enter key to complete the formula. The answer 5 appears in cell D3. Even though the answer...
J
James Smith 22 minutes ago
You now know how to use cell references in an Excel formula.

Change the Formula Data

To t...
D
Press the Enter key to complete the formula. The answer 5 appears in cell D3. Even though the answer to the formula is shown in cell D3, selecting that cell displays the formula in the formula bar above the worksheet.
David Cohen Member
access_time 11 minutes ago
Press the Enter key to complete the formula. The answer 5 appears in cell D3. Even though the answer to the formula is shown in cell D3, selecting that cell displays the formula in the formula bar above the worksheet.
thumb_up Like (13)
comment Reply (0)
thumb_up 13 likes
A
You now know how to use cell references in an Excel formula. <h2> Change the Formula Data </h2> To test the value of using cell references in a formula, make a change to the number in cell B3 and press Enter. The answer in cell D3 automatically updates to reflect the change in data in cell B3.
Andrew Wilson Member
access_time 12 minutes ago
You now know how to use cell references in an Excel formula.

Change the Formula Data

To test the value of using cell references in a formula, make a change to the number in cell B3 and press Enter. The answer in cell D3 automatically updates to reflect the change in data in cell B3.
thumb_up Like (1)
comment Reply (0)
thumb_up 1 likes
E
A common mistake is selecting outside of the formula cell to leave formula-editing mode. This inserts the selected cell into the formula. Instead, when you&#39;re done editing a formula, press Enter to leave formula-editing mode.
Evelyn Zhang Member
access_time 13 minutes ago
A common mistake is selecting outside of the formula cell to leave formula-editing mode. This inserts the selected cell into the formula. Instead, when you're done editing a formula, press Enter to leave formula-editing mode.
thumb_up Like (11)
comment Reply (1)
thumb_up 11 likes
comment 1 replies
K
Kevin Wang 12 minutes ago

Order of Operations Using Parenthesis

Excel has an order of operations that i...
H
<h2> Order of Operations Using Parenthesis </h2> Excel has an&nbsp;order of operations&nbsp;that it&nbsp;follows when evaluating which mathematical operations&nbsp;to carry out first in a formula. Excel follows the standard math principles of the order of operations: Anything inside of parenthesis is calculated first.Multiplication and division are performed next.Addition and subtraction are calculated last. If you prefer to subtract two cells in Excel before multiplication or division, add parenthesis around the subtraction.
Henry Schmidt Member
access_time 70 minutes ago

Order of Operations Using Parenthesis

Excel has an order of operations that it follows when evaluating which mathematical operations to carry out first in a formula. Excel follows the standard math principles of the order of operations: Anything inside of parenthesis is calculated first.Multiplication and division are performed next.Addition and subtraction are calculated last. If you prefer to subtract two cells in Excel before multiplication or division, add parenthesis around the subtraction.
thumb_up Like (19)
comment Reply (0)
thumb_up 19 likes
D
In the example, placing A3-B3 inside parenthesis before /A5 subtracts 5 from 10 before dividing by 20. The result of this formula is 0.25. If the parenthesis were not used in this formula, the result would be 9.75.
David Cohen Member
access_time 45 minutes ago
In the example, placing A3-B3 inside parenthesis before /A5 subtracts 5 from 10 before dividing by 20. The result of this formula is 0.25. If the parenthesis were not used in this formula, the result would be 9.75.
thumb_up Like (42)
comment Reply (3)
thumb_up 42 likes
comment 3 replies
C
Charlotte Lee 12 minutes ago

Create More Complex Formulas

To expand formulas to include additional operations (such as...
R
Ryan Garcia 43 minutes ago
Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Othe...
Show 1 more replies
J
<h2> Create More Complex Formulas </h2> To expand formulas to include additional operations (such as division or addition) as shown in row seven,&nbsp;continue to add the correct mathematical operator followed by the cell reference containing the new data. Was this page helpful?
Julia Zhang Member
access_time 48 minutes ago

Create More Complex Formulas

To expand formulas to include additional operations (such as division or addition) as shown in row seven, continue to add the correct mathematical operator followed by the cell reference containing the new data. Was this page helpful?
thumb_up Like (7)
comment Reply (2)
thumb_up 7 likes
comment 2 replies
N
Nathan Chen 23 minutes ago
Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Othe...
K
Kevin Wang 7 minutes ago
Cookies Settings Accept All Cookies...
N
Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Subtract Dates in Excel Google Sheets Formula Tutorial How to Add Numbers in Excel Using a Formula How to Use the Excel DATE Function How to Combine the ROUND and SUM Functions in Excel How to Count Data in Selected Cells With Excel's COUNTIF Function Use Excel's EOMONTH Function to Add or Subtract Months How to Round Numbers Down in Excel With the ROUNDDOWN Function How to Use the Round Function in Excel How to Calculate Weighted Averages in Excel With SUMPRODUCT Excel Math: How to Add, Subtract, Divide, and Multiply How to Calculate Percentage in Excel Excel SUMIFS: Sum Only Values Meeting Multiple Criteria Excel QUOTIENT Function: Divide Numbers How to Use a Dynamic Range in Excel With COUNTIF and INDIRECT How to Nest Multiple IF Functions in Excel Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.
Natalie Lopez Member
access_time 34 minutes ago
Thanks for letting us know! Get the Latest Tech News Delivered Every Day Subscribe Tell us why! Other Not enough details Hard to understand Submit More from Lifewire How to Subtract Dates in Excel Google Sheets Formula Tutorial How to Add Numbers in Excel Using a Formula How to Use the Excel DATE Function How to Combine the ROUND and SUM Functions in Excel How to Count Data in Selected Cells With Excel's COUNTIF Function Use Excel's EOMONTH Function to Add or Subtract Months How to Round Numbers Down in Excel With the ROUNDDOWN Function How to Use the Round Function in Excel How to Calculate Weighted Averages in Excel With SUMPRODUCT Excel Math: How to Add, Subtract, Divide, and Multiply How to Calculate Percentage in Excel Excel SUMIFS: Sum Only Values Meeting Multiple Criteria Excel QUOTIENT Function: Divide Numbers How to Use a Dynamic Range in Excel With COUNTIF and INDIRECT How to Nest Multiple IF Functions in Excel Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up Newsletter Sign Up By clicking “Accept All Cookies”, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts.
thumb_up Like (34)
comment Reply (2)
thumb_up 34 likes
comment 2 replies
J
Joseph Kim 21 minutes ago
Cookies Settings Accept All Cookies...
B
Brandon Kumar 4 minutes ago
How to Subtract Two or More Numbers in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! ...
S
Cookies Settings Accept All Cookies
Sophie Martin Member
access_time 72 minutes ago
Cookies Settings Accept All Cookies
thumb_up Like (40)
comment Reply (3)
thumb_up 40 likes
comment 3 replies
H
Harper Kim 19 minutes ago
How to Subtract Two or More Numbers in Excel GA S REGULAR Menu Lifewire Tech for Humans Newsletter! ...
L
Luna Park 41 minutes ago
This article covers how to handle simple and complicated subtraction formulas in Excel. The instruct...
Show 1 more replies

Write a Reply

Similar Discussions