How to Subtract Numbers in Excel (Basic way)

How to subtract numbers in Excel (Basic way)

In this short tutorial I’ll show you how to easily subtract numbers in Excel.

Let’s not lose any more time – this is how it’s done!

See the video tutorial and transcription below: 

See this video on YouTube:  
https://www.youtube.com/watch?v=1ElcsZpA3h4 

Basic Way How to Subtract Numbers in Excel

To start with, it’s important to realize that there’s more than one way how to do subtraction in Excel, and these methods are more advanced. Here we’re gonna concentrate on the basic, simple way how to subtract two numbers in a table.

We’ll use this table as an example to show how to work out anything we need, step by step. There are numbers written in columns A and B. Thanks to an easy formula, we’ll subtract them and the result will appear in column C.

How to subtract numbers in Excel - subtract two numbers

First, click on the cell in which you want to display the result. Let’s select cell C2 for our first calculation.

Now, find the ‘equal’ key and press it. This works as some kind of signal to Excel that we want to enter a formula in the cell.

Then we click on the cell that contains the first number to be subtracted, in this case, it’s cell A2. Once we’ve selected the cell, we can see how another part of the formula appeared after the ‘equal’ sign – it’s the cell reference, A2.

Next, we need to add the symbol for the mathematical operation we want to carry out, so we’ll use a minus sign, which is used for subtraction in Excel.

After that, click on the cell which contains the minuend, which is B2.

How to subtract numbers in Excel - put formula into the cell

So, what we’ve just done is that we’ve told Excel to subtract the number in cell B2 from the number in cell A2.

Press ‘Enter’ and you’re done! The result is available at once.

How to subtract numbers in Excel - how to get result

You can use similar steps to add, multiply or even divide in Excel. You can watch separate tutorials that describe how to do these calculations in more detail.

But this is not all! Here comes a handy little ‘lifehack’ just for you!

How to Copy Formula into Adjacent Cells by Using the Fill Handle

If you need to subtract  the numbers in rows 3 and 4, click on the cell containing the formula we’ve just created, which is cell C2.

Hover over the bottom right corner of the cell until you see a cross symbol, then use left-click to drag the formula down through the rest of the rows.

How to subtract numbers in Excel - use formula in whole column

And that’s it! Well done! You’ve managed to subtract the numbers in all three rows!

Would you like to know:

If you’ve found this tutorial helpful, like us and subscribe to receive more videos from EasyClick Academy. Look at more tutorials that help you use Excel quick and easy!

See you in the next tutorial!

Comments

Add comment

Your email address will not be published.

Your personal information will only be used for the purpose of processing this comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.