now we need to find a Balance Amount in cell B7 after subtracting the values of products. In this above Subtraction example, we have a list of Products and Total Amount in cell B1. but with the help of SUM function, it is easy to subtract multiple ranges of cells in Excel. ![]() If you want to subtract multiple cell ranges using a minus sign, it will take more time to subtract individually. In this example, using minus (-) sign we have subtracted four values in a single cell A1. here we have subtracted B5 cell value C5 cell value. 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 used formula to subtract in Excel is=B5-C5. Syntax:=(Value1-Value2) Or=Value1-Value2 Excel Subtraction Examples: in Excel, you use cell references to subtract numbers instead of giving actual numbers. In the same way, we can apply a minus sign to do subtraction in Excel. In the previous Excel Addition Tutorial, we have already discussed how to use Arithmetic Operator sign to do addition. We all know from primary schools that to subtract one number from another number we should use a minus sign. ![]() using a minus (-) Arithmetic Operator sign, we can subtract any two values in Excel. Subtract Function in Excel: There is no direct formula to subtract in Excel. ![]() Subtraction | Subtraction Syntax | Subtraction Examples | Download the Sample File
0 Comments
Leave a Reply. |