Pinterest Pixel

Subtraction Formula in Excel

What does it do? Subtracts two numbers Formula breakdown: =number1 – number2 What it means: =the number being deducted... read more

Download Excel Workbook
Bryan
Posted on

Steps To Follow

Overview

Subtraction Formula in Excel | MyExcelOnline Subtraction Formula in Excel | MyExcelOnline

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 workbookSUBTRACTION-FORMULA.xlsx

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!

See also  INDEX and MATCH Made Simple

Subtraction Formula in Excel

How to Use the Subtraction Formula in Excel

 

 

If you like this Excel tip, please share it
Subtraction Formula in Excel | MyExcelOnline Subtraction Formula in Excel | MyExcelOnline
Subtraction Formula in Excel | MyExcelOnline
Bryan

Bryan is a best-selling book author of the 101 Excel Series paperback books.

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...