• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Subtract in Excel

April 6, 2021 by Andrew Childress
Sorted subtraction Excel

One of the four basic math operations, subtraction is a breeze in a spreadsheet even with large numbers. Let's learn how to subtract in Excel.

One of the four basic math operations, subtraction is a breeze in a spreadsheet. That’s true even with large numbers – no pen and paper needed. Let’s learn how to subtract in Microsoft Excel.

How to Subtract in Excel (With New Values)

Though the concept is simple, subtraction can become difficult, especially if you’re working with large, non-round values. Fortunately, Microsoft Excel has you covered. It’s easy to subtract two or more numbers, with just a few keystrokes.

Let’s say you want to subtract 2174 from 5003. To do it, begin by clicking into any empty cell in your file. Start by typing an = sign, which tells Excel that you’re going to be building a formula in that cell.

Type 5003, then press – on your keyboard. Finish by typing 2174. Your finished formula reads:

=5003-2174

Subtract Excel

Go ahead and press the Enter key on your keyboard. Excel returns your solution in the cell: 2829. Isn’t that easier than solving on paper?

If you want to subtract more than one number, simply continue typing. For example, you can remove 1000 by changing your formula to read:

=5003-2174-1000

Subtract in Excel

How to Subtract in Excel (With Existing Values)

Now, imagine you have some numbers and want to subtract them from each other. They’re already on your spreadsheet, so you don’t want to type them in again.

Find an empty cell, and repeat the earlier step of typing =. Now, click on the cell containing your first number. Here, that’s cell B2. Then, type –, and click on cell C2. Finally, type – again, and click cell D2. Your subtraction formula now reads:

=B2-C2-D2.

How to subtract in Excel

Press Enter, and Excel will instantly perform the subtraction.

As you can see, Microsoft Excel makes basic math equations simple. It’s a true timesaver, especially when you’re working with lengthy, complex, or multiple values at once.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Substrings ExcelSubstring in Excel
Next Post:Header in ExcelHeader Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top