Skip to content
Home How To How to Subtract in Excel: A Step-by-Step Guide

How to Subtract in Excel: A Step-by-Step Guide

How to Subtract in Excel: A Step-by-Step Guide
Subtracting numbers in Microsoft Excel might seem a bit complex at first, but it’s quite manageable once you get the hang of it.

In this article, we’ll walk you through four different methods to perform subtraction in Excel: directly within a cell, using cell references, employing the SUM function, and leveraging the status bar. Depending on your preferences and needs, you can choose the method that suits you best. Continue reading to learn how to subtract using Excel.

Subtracting Within a Cell

If you just need to quickly subtract two numbers, you can easily do this within a single cell in your Excel worksheet.

Step 1: Click on a blank cell in your sheet and type the following (exclude the brackets and spaces):

=[first number] [second number]

For example, you might enter: =9-1

Image used with permission by copyright holder

Step 2: Next, press Enter on your keyboard.

The result of your subtraction should appear instantly, replacing the formula you entered.

In this case, the result would be 8.

The outcome displayed after subtracting two numbers in Excel.
Image used with permission by copyright holder

Subtracting Using Separate Cells

If the numbers you want to subtract are in different cells, you can utilize cell references alongside a formula.

Step 1: Identify the numbers you wish to subtract and record their cell references. A cell reference indicates a cell’s position in the spreadsheet, defined by its column and row. For example, if one of your values is in Column A, Row 6, its reference would be A6.

Step 2: Click on an empty cell and enter the following formula, replacing the placeholders with your specific cell references:

=[cell reference for the first number] [cell reference for the second number]

For instance, you may enter: =A5-A6

Subtracting numbers in different cells using cell references.
Image used with permission by copyright holder

Step 3: Press Enter.

The result of the subtraction will appear in place of the formula you just used.

For our values where A5 is 444 and A6 is 227, the resulting value will be 217.

(You can safeguard the formulas and data by locking certain cells within the spreadsheet.)

The final result obtained using cell references for subtraction in Excel.
Image used with permission by copyright holder

Subtracting with the SUM Function

Excel may not feature a dedicated subtraction function, but you can leverage the SUM function to perform subtractions as well.

Step 1: Click on a blank cell and type the formula below, substituting your own numbers as needed:

=SUM(first number,-second number)

Note: You can designate either number as negative for the subtraction to be carried out.

For example, to subtract 227 from 444, you might use:

=SUM(444,-227)

or alternatively:

=SUM(-227, 444)

Employing the SUM function to subtract in Excel.
Image used with permission by copyright holder

Step 2: Hit Enter on your keyboard.

The answer should instantly replace the formula you inputted.

In our example, the answer would be 217.

Using the Status Bar for Subtraction

You can also subtract numbers without entering a formula by using Excel’s status bar, which is located at the bottom of the application. Simply enter your numbers into separate cells, making one of them negative. For example, to subtract 227 from 444, type 444 in one cell and -227 in the adjacent cell.

Next, select both cells. Look at the status bar at the bottom of your screen, where you will find the result displayed next to SUM:.

Utilizing the status bar in Excel for subtraction.
Image used with permission by copyright holder

Writing formulas to subtract values in Excel can be simple, yet it also offers more advanced applications. Mastering fundamental arithmetic in spreadsheets will help you maximize your productivity with this software. If you feel confident, consider exploring multiplication in Excel.

After that, familiarize yourself with Excel’s keyboard shortcuts to further enhance your efficiency with the program.

  • Rebecca Fraser

    Rebecca covers all aspects of Mac and PC technology, including PC gaming and peripherals, at Digital Phablet. Over the previous ten years, she built multiple desktop PCs for gaming and content production, despite her educational background in prosthetics and model-making. Playing video and tabletop games, occasionally broadcasting to everyone's dismay, she enjoys dabbling in digital art and 3D printing.

Leave a Reply

Your email address will not be published. Required fields are marked *

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