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:


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


Subtraction Formula in Excel


STEP 2: Enter the subtraction operator


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



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


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

10 + 1 Ways to Round Numbers in Excel This is a guest post by Alan Murray from Computergaga. There are many ways to round numbers in Excel. These techniques will typically involve formatting the values, or using formulas. This post will look at 10 rounding functions of Excel, and then look at some formatting te...
Add the Calculator to the Excel Toolbar There were times when I had to find my Calculator App while I was doing some quick calculations in Excel. Instead of scrambling for the Calculator Application, you can actually have this inside of Excel! Excel has a lot of customizations and one handy tool is to include the...
Excel Subtotal Function – Avoid Double Count... What does it do? It returns a Subtotal in a list or database Formula breakdown: =SUBTOTAL(function_num, ref1) What it means: =SUBTOTAL(function number 1-11 includes manually-hidden rows & 101-111 excludes them, your list or range of data) ***Go to the bottom...
Get the Average of Values with Excel’s AVERA... What does it do? Gives you the average of a group of values Formula breakdown: =AVERAGE(number1, number2...) What it means: =AVERAGE(the numbers you want to average)   There are times when you have to get the average of your values in your Excel work...