+4 votes
254 views
Subtract in Excel 2019 and Excel 2016

in Office by (551k points)
reopened | 254 views

1 Answer

+5 votes
Best answer

Subtract in Excel 2019 and Excel 2016

Talking about operations in Microsoft Excel 2016/2019 can be a terrifying topic for thousands of users, but it is not like that at all if you know the correct way to use its formulas and functions , one of the most basic is to subtract values ​​there, subtract it It is one of the essential mathematical operations and in Excel this is automated so that we do not suffer and have the correct results..

 

Excel is a great data manager when we need to make spreadsheets applying different operations, among the most basic the one we name today, subtraction in Excel . To be able to calculate different numbers we need these formulas, although we could also manually, in this case there are some options to perform subtractions in Microsoft Excel and we will see them in detail throughout this tutorial.

 

 

To stay up to date, remember to subscribe to our YouTube channel!   SUBSCRIBE

 

 

Subtract in Excel 2019 and Excel 2016

 

Step 1

One of the easiest ways to subtract in Excel is using the data from the rows and columns, for example, we can use the following:
 = A2-A3 
image

 

 

Step 2

This is responsible for taking the value of A2 and subtracting the value that is in row A3, if we change any of the values ​​of these rows the result will be automatically modified:

 

 

image

 

 

Step 3

Another option to subtract in Excel 2016 or 2019 is by directly entering the values ​​to use, for example, we can use the following. This basically becomes a manual but not automatic way of subtracting in Excel.
 = 100-45 
image

 

 

Step 4

Finally, Excel offers us a function to obtain subtraction results, this is originally for addition, but in case there are negative numbers in the range to be used, these will be applied as a subtraction in the operation, with the SUM function we achieve this, by example.

 

In this case, the value of A5 is negative, so it will be subtracted from the sum of A3 and A4..

 = SUM (A3: A5) 
image

 

 

With these simple methods we can subtract in Excel 2016 or 2019 with 100% safe results.

 


by (3.5m points)

Related questions

+4 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (551k points) | 320 views
+4 votes
1 answer
asked Oct 21, 2019 in Office by backtothefuture (551k points) | 290 views
+3 votes
1 answer
asked Sep 19, 2019 in Office by backtothefuture (551k points) | 342 views
+3 votes
1 answer
asked Sep 15, 2020 in Office by backtothefuture (551k points) | 541 views
+3 votes
1 answer
asked Jul 7, 2020 in Office by backtothefuture (551k points) | 418 views
Sponsored articles cost $40 per post. You can contact us via Feedback
10,632 questions
10,764 answers
510 comments
3 users