Home Education Excel Subtraction Formula: How to Subtract in Excel

Excel Subtraction Formula: How to Subtract in Excel

At some point, you may need to perform subtraction in Excel to get the difference between two numbers. Fortunately, Excel offers several ways to subtract numbers, and we’re going to cover them all in this article.

Subtraction Formula in Excel

The easiest way to subtract in Excel is to use the subtraction formula. To do this, you need to follow the steps below:

  1. Select the cell where you want the result to appear.
  2. Type the formula =A1-B1, where A1 and B1 are the cells containing the numbers you want to subtract.
  3. Press Enter.

Excel will then display the result of the subtraction in the selected cell.

Subtraction Using Excel Functions

Excel also provides several built-in functions that can be used to subtract numbers. Here are the most commonly used functions:

1. MINUS Function

The MINUS function in Excel subtracts numbers and returns the result. To use the MINUS function, you need to follow the steps below:

  1. Select the cell where you want the result to appear.
  2. Type the formula =MINUS(A1,B1), where A1 and B1 are the cells containing the numbers you want to subtract.
  3. Press Enter.

Excel will then display the result of the subtraction in the selected cell.

2. SUBTRACT Function

The SUBTRACT function in Excel subtracts numbers and returns the result. To use the SUBTRACT function, you need to follow the steps below:

  1. Select the cell where you want the result to appear.
  2. Type the formula =SUBTRACT(A1,B1), where A1 and B1 are the cells containing the numbers you want to subtract.
  3. Press Enter.

Excel will then display the result of the subtraction in the selected cell.

3. SUM Function with Negative Values

Another way to subtract in Excel is to use the SUM function with negative values. To do this, you need to follow the steps below:

  1. Select the cell where you want the result to appear.
  2. Type the formula =SUM(A1,-B1), where A1 and B1 are the cells containing the numbers you want to subtract.
  3. Press Enter.

Excel will then display the result of the subtraction in the selected cell.

Subtraction Using Excel Formulas

Excel also provides some formulas that can be used to subtract numbers. Here are some examples:

1. MIN Function

The MIN function in Excel returns the smallest number from a range of cells. To use the MIN function for subtraction, you need to follow the steps below:

  1. Select the cell where you want the result to appear.
  2. Type the formula =MIN(A1,B1)*-1, where A1 and B1 are the cells containing the numbers you want to subtract.
  3. Press Enter.

Excel will then display the result of the subtraction in the selected cell.

2. SUM Function with a Negative Range

Another way to subtract in Excel is to use the SUM function with a negative range. To do this, you need to follow the steps below:

  1. Select the cell where you want the result to appear.
  2. Type the formula =SUM(A1:B1)*-1, where A1 and B1 are the cells containing the numbers you want to subtract.
  3. Press Enter.

Excel will then display the result of the subtraction in the selected cell.

Conclusion

Subtracting numbers in Excel is a simple task, and Excel provides several ways to do it. You can use the subtraction formula, Excel functions, or Excel formulas to get the difference between two numbers. By using these methods, you can perform subtraction easily and quickly in Excel.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Must Read

Accessori Elisabetta Franchi: The Art of Italian Elegance and Craftsmanship

Elisabetta Franchi is synonymous with Italian luxury, sophistication, and a dedication to high-quality fashion. While the brand is celebrated for its stylish...

Bring Your Photos to Life with Canvas Prints Calgary: Top-Quality Art and Free Shipping Across North America

In our digital world, precious memories are often trapped on screens, unseen and unappreciated. At Canvas Prints Calgary, we offer a way...

The Strength of Nutrition: Healing Your Body with the Right Foods

In the modern world, the good health of the person and the nutritional benefits that people generally may gain cannot be overemphasized....

What is a Steam Key? Understand Its Functions and How to Get One

In digital gaming, the term Steam key is something many gamers come across frequently. But what exactly is a Steam key, and...

Unveiling the Latest Trends in Google AdWords Management Strategies for Businesses

In the ever-evolving world of digital marketing, staying ahead of the curve is crucial for businesses looking to maximise their online presence....