What does it do?

Subtracts two numbers

Formula breakdown:

=number1 – number2

What it means:

=the number being deducted from – the number being deducted


In Excel subtracting numbers together is really easy, the Subtraction Formula is actually through the use of the subtraction operator:

I will show you in the steps below how you could use this.

This is the table of values that we want to perform subtraction on:

Subtraction Formula in Excel

I explain how you can do this below:

Subtraction Formula in Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: We need to enter the number we want to subtract:

=C9

Subtraction Formula in Excel

 

STEP 2: Enter the subtraction operator

=C9

Subtraction Formula in Excel

 

STEP 3: Enter the number doing the subtracting:

=C9 – D9

Subtraction Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have all of the subtraction results!

Subtraction Formula in Excel

How to Use the Subtraction Formula in Excel

 

 

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn