zakruti.com » IT - Software » Geeks Tutorial

How to Subtract in Excel Excel Minus Formula [Beginners Tutorial / Easy Excel formulas]

video description

Rating: 4.0; Vote: 1

we'll teach you how to subtract in Excel by using a formula. Lets suppose a company only sells two products. Over here, we have the data for total units sold and how many times Product A was sold for each month. If we want to find out the total units sold for product B, we can simply minus Product A with total Units sold for each month. For that, we will select the cell where we want the result to appear and start typing the formula. All formulas in excel start with an equals to sign, so lets enter that here. Now, the easiest way to go about is just enter the numbers in the formula. So for example, I can simply write in the formula Seven Hundred Minus Five Hundred. For the Minus Sign, you can use the minus key on the numeric keypad section of your keyboard. Alternatively, you can use the hyphen key on the keyboard as well. Once you hit enter, itll give you the correct answer. The problem is, if we change the data in this cell, then the numbers for Product B wont be automatically updated. A simpler way would be to select the cell reference in the formula. That way, we can copy and paste the formula for the remaining months as well. So, after the equals to sign, lets select the cell from Total Units Sold, enter the minus sign and now lets select the cell from Product A. Once you hit enter, you can see that it has deducted Product A from the Total Units Sold for the month of February. Now if you change the numbers, the result will automatically update. What if the data was presented in a different manner? For example, if the cells contained a negative number. Here, we can simply use the SUM function that will add all the numbers in the range and subtract any value that is a negative number. So, over here, lets enter the equal to sign followed by SUM and open bracket. Now, we would be required to select the range. So lets select both the cells for Total Units Sold and Product A. Once we hit enter, you can see here that excel has deducted the values in Product A from Total Units sold
Date: 2023-07-08

← How to Compare Two Versions of a Document in Word Track Changes Document by Comparing Two Files

How to Insert a Checkbox in Word Make a Checklist in Word Add a Fillable Checkbox in Word →

Related videos

Corsair, Get It Together

• Gamers Nexus

Now Watch YouTube Inside Photoshop! (Free)

• PiXimperfect

Nano Banana vs Photoshop: A Fair Comparison

• PiXimperfect

HW News - AMD Says AI Definitely, Absolutely Not A Bubble, New Chinese CPUs, RAM Rip-Off Continues

• Gamers Nexus

How to Delete Google Account Permanently (Quick & Easy)

• Geeks Tutorial

Turn Off This Hidden Parasite on Every Phone! (Android)

• Geeks Tutorial

Comments and reviews: 8

Heretic
How do you copy a formula e. g. =(A1- C1) But then make numbers increase by one as you proceed down the column without having to manually change each number in the formula to match the respective row number? e. g Row 2: = (A2-C2); Row 3 =(A3-C3. etc?
reply

Raeven
I am trying to make a partial payment tracking form for purchase orders. I need to be able to have the line items in rows and have then automatically subtract from the original amount when I press enter.
reply

Snippets
this is great but I'm wondering why I can't copy and paste formulas to the left or to the top? Like it cuts off most of my formula. I can only paste to the right or the bottom.
reply

Jessica
I'm trying to subtract a column total from another column total, to see how many items we don't need, I have a header for the column and can't put the formula there?
reply

Hungry
how to get this value of subtraction in. 5? For example Cell A1 - 0. 5 should show 1-. 5 =. 5 how to do that? It is always round up to 1
reply

MultiVictor56
i like to sum plus sum then minus to a total amount. in the same cell horizontal in mac computer please
reply

shanks008
Thank you. How can you use this formula to substract contents of 2 columns but excluding hidden rows?
reply

Troy
How to show a zero difference if the minuend or subtrahend is not present in a excel subtraction problem?
reply

Add a review, comment