Need a hand with subtracting in Excel? Let Sharyn guide you through creating a subtraction formula in Excel AND how to avoid getting incorrect results from your subtraction formulas.
Hi, how to add or deduct a value in a cell basing on the sign of outcome of subtracting value from previous two cells : Example: A - B = C (Here A and B are independent variables thereby the sign of value in C could be positive or negative.) Next Step is C + D or C - D viz if value in C is negative, it would be C+D else it would be C-D. How do I write a one line command for the above. Pl guide
Hi JT. Just include the extra cell into your formula. Let's say A4 held the total and you wanted to subtract the amount in B4 and C4. Then your formula would be =A4-B4-C4. Just remember to use your brackets if you are wanting to calculate part of the formula first. For example if you wanted to add the 2 spent amounts first and then subtract that amount from the total you would be best to write the formula =A4-(B4+C4). I hope this is helpful 😊
Hi! If I do a start and end time where there is an additional down time amount to also be subtracted would the formula in the output cell be for example =B2-A2-C2. ??? I may be stumped!
Hi Lulu. Without seeing your data it's pretty hard to give you a definite answer. Feel free to email an example of what you are trying to achieve to ask@excelatwork.co.nz and we will see if we can help.
I appreciate your videos so much. I need help to create a formula to subtract fixed values uning reference cells from another sheet in athe workbook. I have a workbook with 13 sheets, of which 12 are for Months from January thru December. I need to subtract amount paid every Month to get the new outstanding balance, until is paid off. There are no interest in this calculation. any guidance is really appreciated.
Hi there. Just pop the cell or value you are wanting to subtract at the end of your SUM function, e.g. =SUM(A1:A23)-100 or =SUM(A1:A23)-B3. I hope this helps :-)
Hi Vijay. Microsoft tells us "There is no SUBTRACT function in Excel. Use the SUM function and convert any numbers that you want to subtract to their negative values. For example, SUM(100,-32,15,-6) returns 77". I hope this helps.
Hi Egor. Sorry to hear you are experiencing an error. Can you please check that the cells you are using in your formula don't contain text OR aren't set to a Number Format of Text? This can be a killer for receiving a #VALUE error. If the cell contains text try overtyping it with a number. If the cell Number Format is set to Text, please try changing it to 'General'. Thank you.
Hi there. There are several methods for doing this. You could reference the cells individually, e.g., if you were subtracting cell B1 and C1 from a value in cell A1 the formula would be =A1-B1-C1. If you have a range of cells you might like to use the SUM function to first calculate the total of the range that will be subtracted, e.g. =A1-SUM(B1:F1). I hope this helps.
Need a hand with subtracting in Excel? Let Sharyn guide you through creating a subtraction formula in Excel AND how to avoid getting incorrect results from your subtraction formulas.
Excellent one. Good to know some of these basics as we keep forgetting
Glad it was helpful!
This was interesting anf helpful. Going to save me a lot of time keeping track of PO totals :) Thank you
You're so welcome. I'm really happy it helped you :)
Thank you so much. This tutorial has really helped me improve my skills in excel.
Great to hear! Thank you so much for your comment!!
Thanks I am learning something new
Glad to help
Very good instructions
Thank you. So glad it was helpful!
Super helpful. Thank you!!
You're welcome!
Thanks you made very easy
You are welcome 😊
Hi, how to add or deduct a value in a cell basing on the sign of outcome of subtracting value from previous two cells : Example: A - B = C (Here A and B are independent variables thereby the sign of value in C could be positive or negative.) Next Step is C + D or C - D viz if value in C is negative, it would be C+D else it would be C-D. How do I write a one line command for the above. Pl guide
Hi Sharyn - i was wondering if you could tell me when you use =SUM in excel. thanks
Hi Kelly. Sure! Please check out my blog page on =SUM here excelatwork.co.nz/2018/06/13/total-a-range-of-cells-in-excel/. Have a great day 😀 Sharyn
Good video but what if you had TWO 'Spent' columns? How would you create the formula for that ??
Hi JT. Just include the extra cell into your formula. Let's say A4 held the total and you wanted to subtract the amount in B4 and C4. Then your formula would be =A4-B4-C4. Just remember to use your brackets if you are wanting to calculate part of the formula first. For example if you wanted to add the 2 spent amounts first and then subtract that amount from the total you would be best to write the formula =A4-(B4+C4). I hope this is helpful 😊
Hi! If I do a start and end time where there is an additional down time amount to also be subtracted would the formula in the output cell be for example =B2-A2-C2. ??? I may be stumped!
Hi Lulu. Without seeing your data it's pretty hard to give you a definite answer. Feel free to email an example of what you are trying to achieve to ask@excelatwork.co.nz and we will see if we can help.
Chur Sharyn. Can you please give a demo on making a Gantt Chart next?
+Lazarus Bean great idea! Will put that one my list. Thanks for asking. Have a great day!
I appreciate your videos so much. I need help to create a formula to subtract fixed values uning reference cells from another sheet in athe workbook. I have a workbook with 13 sheets, of which 12 are for Months from January thru December. I need to subtract amount paid every Month to get the new outstanding balance, until is paid off. There are no interest in this calculation. any guidance is really appreciated.
How do you subtract something from a sum function
Hi there. Just pop the cell or value you are wanting to subtract at the end of your SUM function, e.g. =SUM(A1:A23)-100 or =SUM(A1:A23)-B3. I hope this helps :-)
fantastic
Thank you so much 😀
Your title was HOW TO Subtract but you only show the most simple but you didn't show how to do multiple cells in subtraction.
Like SUM .. is there any way we can do substraction..?
Hi Vijay. Microsoft tells us "There is no SUBTRACT function in Excel. Use the SUM function and convert any numbers that you want to subtract to their negative values. For example, SUM(100,-32,15,-6) returns 77". I hope this helps.
Excele-lent :)
😄 Thank you!
My excel shows - instead of the result..
I am getting a #VALUE error when i want to subtract those numbers, what could i do?
Hi Egor. Sorry to hear you are experiencing an error. Can you please check that the cells you are using in your formula don't contain text OR aren't set to a Number Format of Text? This can be a killer for receiving a #VALUE error. If the cell contains text try overtyping it with a number. If the cell Number Format is set to Text, please try changing it to 'General'. Thank you.
Thank you for such a great, and easy to understand, tutorial. I have given my thumbs up and have subscribed. 🙂
Awesome, thank you so much!
IS THERE ANYA SPECIAL FURMULA FOR SUBTRACTING MULTIPLE VALUES
Hi there. There are several methods for doing this. You could reference the cells individually, e.g., if you were subtracting cell B1 and C1 from a value in cell A1 the formula would be =A1-B1-C1. If you have a range of cells you might like to use the SUM function to first calculate the total of the range that will be subtracted, e.g. =A1-SUM(B1:F1). I hope this helps.
@@ExcelatWork Yes! thank you so much
@@ExcelatWork Finally!! That is the one I was looking for. VERY helpful! Thank you -