WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Excel Minus Formula

Excel Minus Formula

By Jeevan A YJeevan A Y | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

Minus Formula in Excel

In excel we do not have any inbuilt formula for subtraction or minus, we use minus operator (-) to do the arithmetical subtraction in excel, to subtract two values  from each other we need to also use the equals to operator to make minus a formula, for example, = value 1- value 2 is a minus formula where we subtract value 1 from value 2, note that the values should be in the same format to avoid error in formula.

How to Use Minus Formula in Excel?

For adding two numbers, we have the SUM function in excel. However, we do not have any subtraction formula for minus numbers in excel. A formula should start with an equal sign in the targeted cell.

Assume we have 5 in cell A1 and 3 in cell B1. I want to subtract the value in B1 from A1. I want the result to be shown in cell C1. The formula in the cell C1 should read like this =A1 – B1.

Excel Minus Formula 1

We can also directly enter the values to the cell C1 itself.

Excel Minus Formula 2

Even though we can directly enter the numbers to the formula, it is always recommended to give cell references. Because giving cell references makes the formula dynamic and updates the value automatically if there are any changes.

Examples of Minus Calculation

You can download this Minus Formula Excel Template here – Minus Formula Excel Template

Example #1

I have data on Budgeted Cost vs. Actual Cost for the year 2018. The finance department supplied me with these two data. I need to find out the variance amount whether the budgeted cost is within the limit or not?

Excel Minus Formula Example 1

How do I find out the variance amount? I need to deduct the budgeted cost from the actual cost.

I need to deduct B2 from A2 using the minus formula.

 Example 1.1.1

Press enter to see the result.

Excel Minus Formula Example 1.1.2

Now drag the minus formula to cell C9 for the other values to be determined,

Example 1.3

From the above result, it is clear that only one item is within the budget, i.e., C6 cell. If the variance is negative, then it is over the budgeted number, and if the variance is positive, then it is within the budgeted number.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Example #2

We know the basics of minus calculation. In this example, we will look at how to deal with one negative number and one positive number.

I have data on Quarterly profit and loss numbers.

Excel Minus Formula Example 2

I need to find the variance from Q1 to Q2, Q3 to Q4, Q5 to Q6.

The usual formula should be Variance = Q1 – Q2, Variance = Q3 – Q4, Variance = Q5 – Q6.

Example 2.0.1

Case 1:

Now look at the first variance in the Q1 loss was -150000 in the second Q2 profit is 300000, and the overall variance should be a profit of 150000. But formula displays -450000. This is one of the drawbacks of blindly using the minus formula in excel.

We need to alter the formula here. Rather than subtracting Q1 from Q2, we need to add Q1 to Q2. Since there are a positive number and negative numbers, we need to include the plus sing here. The basic of mathematics is plus * minus = minus.

Excel Minus Formula Example 2.0.2

Case 2:

Now look at the third variance in the Q5 loss was -75000 and in Q6 loss was -125000. The variance should be -50000, not +50000.

We need to subtract in excel the Q6 value from the Q5 value. Since there are two negative numbers, we need to take the highest negative number, and from that number, we need to deduct the other negative number.

 Example 2.0.3

In this way, we need to do the subtraction operations in excel. You should know the basics of mathematics to deal with these kinds of situations.

Example #3

Below is the data are given to me by the sales manager. This data is the individual sales data for his team. Data includes individual target and individual actual sales contribution.

He asked me to find out the variance and efficiency level percentage for each employee.

Excel Minus Formula Example 3

Here first things I need to find the variance, and the formula is Actual – Target, for efficiency, the formula is Actual / Target, and for Variance %, the formula is Efficiency % – 1.

Calculate Variance Amount

 Example 3.1

The variance amount is calculated by subtracting Actual from the Target number.

Now drag the formula to cell D10 for the other values to be determined,

Excel Minus Formula Example 3.2

Calculate Efficiency Percentage

 Example 3.3

Efficiency is calculated by dividing the Actual by Target. (if the result shows in decimals, apply percentage formatting)

Now drag the formula to cell E10 for the other values to be determined,

Excel Minus Formula Example 3.4

Calculate Variance Percentage

Example 3.5

Variance percentage is calculated by deducting 1 from an efficiency percentage.

Now drag the formula to cell F10 for the other values to be determined,

Excel Minus Formula Example 3.6

Things to Remember

  • Apply percentage formatting in case of decimal results.
  • We can either directly enter the numbers or give cell reference.
  • Giving cell reference makes the formula dynamic.
  • Always keep in mind the basic mathematics rules.
  • Try to learn the BODMAS rule in mathematics.

Recommended Articles

This has been a guide to Excel Minus Formula. Here we discuss how to use the minus formula in excel with examples and downloadable excel templates. You may also look at these useful functions in excel –

  • Subtract Time in Excel
  • Quotient in Excel
  • Multiply in Excel Formula
  • How to Divide using Excel Formulas?
12 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Minus Formula Excel Template

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More