Subtract Function in Excel: There is no direct formula to subtract in Excel. using a minus (-) Arithmetic Operator sign, we can subtract any two values in Excel.
We all know from primary schools that to subtract one number from another number we should use a minus sign.
In the previous Excel Addition Tutorial, we have already discussed how to use Arithmetic Operator sign to do addition.
In the same way, we can apply a minus sign to do subtraction in Excel. in Excel, you use cell references to subtract numbers instead of giving actual numbers.
Here we used formula to subtract in Excel is=B5-C5.
In this above Subtraction example, we need to find the material wise difference amount, for this, we need to subtract the Received Amount from Total Amount with help of minus (-) Arithmetic Operator sign. here we have subtracted B5 cell value C5 cell value.
In this example, using minus (-) sign we have subtracted four values in a single cell A1.
If you want to subtract multiple cell ranges using a minus sign, it will take more time to subtract individually. but with the help of SUM function, it is easy to subtract multiple ranges of cells in Excel.
In this above Subtraction example, we have a list of Products and Total Amount in cell B1. now we need to find a Balance Amount in cell B7 after subtracting the values of products.
To get the Balance Amount, we need to subtract the total SUM of the products from the Total Amount.
Using Absolute reference you can subtract numbers in the range of cells. in the below screenshot the Total Amount value is in the cell B2.
Using the Absolute reference ($) symbol , it is easy to find the difference amount of each product.
It means for every product subtraction, Total Amount is the Same. that means cell B2 value is fixed or frozen.
Before starting any Formula or Function in Excel you need to add (=). to subtract the number in a cell you will need to write a formula in the designated cells.
Kuondoa kazi katika Excel: Hakuna formula ya moja kwa moja ya kuondoa katika Excel. kutumia minus (-) Arithmetic Operator ishara, tunaweza subtract yoyote mbili maadili katika Excel. Sisi sote tunajua kutoka shule za msingi kwamba kuondoa namba moja kutoka namba nyingine tunapaswa kutumia ishara ya chini. Katika uliopita Excel Addition Tutorial, sisi tayari kujadiliwa jinsi ya kutumia Arithmetic Operator ishara ya kufanya kuongeza. Kwa njia ileile, tunaweza kutumia ishara ya chini kufanya uondoaji katika Excel. Katika Excel, wewe kutumia kumbukumbu seli kuondoa namba badala ya kutoa namba halisi. Kwa mfano, kwa mfano, unaweza kutumia formula ya Excel ya kuondoa kwa B5 na C5. Katika mfano huu wa kuondoa, tunahitaji kupata kiasi cha tofauti ya vifaa, kwa hili, tunahitaji kuondoa kiasi cha kupokea kutoka kwa jumla ya jumla kwa msaada wa ishara ya Opereta ya Arithmetic. Hapa tunachukuliwa kutoka kwa B5 na C5 na C5 na C5 na C5 na C5. Katika mfano huu, kutumia - ishara tumekuwa subtracted maadili nne katika seli moja A1. Kama unataka kuondoa mbalimbali nyingi seli kwa kutumia ishara ya chini, itachukua muda zaidi kwa kuondoa moja kwa moja. Kwa mfano, kwa kutumia kazi ya SUM, unaweza kuondoa safu nyingi za seli katika Excel. Katika mfano huu wa juu wa kuondoa, tuna orodha ya Bidhaa na Kiasi cha Jumla katika seli B1. Sasa tunahitaji kupata kiasi cha usawa katika seli B7 baada ya kuondoa maadili ya bidhaa. Ili kupata kiasi cha usawa, tunahitaji kuondoa jumla ya jumla ya bidhaa kutoka jumla ya jumla. Kutumia Absolute rejea unaweza kuondoa namba katika mbalimbali ya seli. Katika picha ya skrini ya chini, thamani ya jumla ya jumla iko katika seli ya B2. Kutumia Absolute rejea ($) ishara, ni rahisi kupata kiasi tofauti ya kila bidhaa. Inamaanisha kwa kila bidhaa subtraction, Jumla ya kiasi ni sawa. Hii inamaanisha kwamba thamani ya seli B2 imewekwa au imefungwa. Kabla ya kuanza yoyote Formula au kazi katika Excel unahitaji kuongeza (=). Kuondoa idadi katika seli unahitaji kuandika formula katika seli maalum.