Minus in Excel Calculations


Home >> How to Use Excel Tutorial >> Excel Calculations >> Minus in Excel Calculations



In this part of our tutorial blog, you will learn about how to do minus in excel calculations. Minus in excel calculations can be done by manual writing or using excel formulas and functions SUM method with a little tweak in the formula so it can be used for excel formulas and functions for the process of minus in excel calculations.


Why We Need to Learn About Minus in Excel Calculations?


Sometimes in our number data, we have “dirty” data that needs subtraction first so that we can get “clean” data that we can use for our analysis. For example, business revenue is often needed to be subtracted with our expense for the operational of the business itself first so that we can get the net profit data. If there is a sales for our product stock, we also need to calculate how many of current product stock we have now by subtracting the amount of product before the sales with the amount of product that we sell.

For that, if we often use this spreadsheet software to keep and process our data, then knowing how to do minus in excel calculations will be very helpful to analyze those kinds of data. For that, understanding how to do minus in excel calculations manually or using excel formulas and functions for subtraction become interesting thing to be done in order to make our data analysis more effective and efficient.


What is Minus in Excel Calculations?


Minus in excel calculations can be done manually or using excel formulas and functions for subtraction. In excel formulas and functions for this need itself, unfortunately there is no excel formulas and functions specifically designed for this calculation. But, we can use excel formulas and functions od SUM which needs a little tweak when doing the formula writing in our spreadsheet. But probably there are more instance that usage of SUM is not too needed by you as it is often simpler to use manual writing to do this kind of calculation in our spreadsheet software.


How to Do Minus in Excel Calculations?


Next part will explain in detail how to do subtraction manually or using excel formulas and functions. Excel formulas and functions used here is by utilizing SUM while manual method is by using minus sign ( - ) in your keyboard.


Manual Method ( - Sign)

  1. Type equal sign ( = ) in the cell where you want to put the calculation result

    Minus in Excel Calculations - Screenshot of Step 1-1

  2. Type number or cell coordinate where the number which you want to do subtraction process on is after = followed by minus sign ( - )

    Minus in Excel Calculations - Screenshot of Step 1-2

  3. Type subtracting number or cell coordinate where the subtracting number is

    Minus in Excel Calculations - Screenshot of Step 1-3

  4. Press Enter
  5. The process of calculation is done for your number!

    Minus in Excel Calculations - Screenshot of Step 1-5




Using Excel Formulas and Functions SUM

  1. Type equal sign ( = ) in the cell where you want to put the calculation result

    Minus in Excel Calculations - Screenshot of Step 2-1

  2. Type SUM (can be with large and small letters) and open bracket sign after =

    Minus in Excel Calculations - Screenshot of Step 2-2

  3. Type the numbers or cell coordinates where you put the numbers to be processed are after open bracket sign with comma sign ( , ) between the numbers or cell coordinates or drag cell cursor from the most top left cell coordinate to the most bottom right if the number cells you want to process are close to each other. Add minus sign ( - ) for the subtracting numbers in the SUM formula.

    Minus in Excel Calculations - Screenshot of Step 2-3

  4. Type close bracket sign after all the numbers or cell coordinates filled with numbers which you want to process have already been inputted

    Minus in Excel Calculations - Screenshot of Step 2-4

  5. Press Enter
  6. The process of calculation is done for your number!

    Minus in Excel Calculations - Screenshot of Step 2-6



Exercise


After you have done learning how to use the two methods explained above, you can practice your understanding to do the calculation in this exercise!

Download the file from below link and answer the questions. Please download the answer to check your result if you have done doing the calculation needed and sure about your result!

Link to download file to train your subtraction calculation understanding:
Download here

Questions

  1. How much gross profit this business has after staff salary?
  2. How much gross profit this business has after processing the number again with material cost? Use SUM formula to answer!
  3. What is the net profit of this business?

Link to download answer:
Download here


Additional Notes

  • In using SUM formula, drag cell cursor and numbers or cell coordinates input with comma sign separation can be done in one writing
  • If you want, cell coordinates which are near to each other can also be written manually separated for the most top left cell and most bottom right cell by two dots sign ( : ) (e.g. SUM(B1:D25))
  • You can do addition and subtraction in one time by using SUM formula. This probably can make your formula writing quicker for calculation process if you are already get used to using SUM for subtraction!




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert