Best Math Formula website. Search anything about Math Formula in this website.
how to use minus formula on excel. In the cell where you want to output the difference type the equals sign to begin your formula. Let me show you a simple example as follows.
Subtracting Numbers In Excel Has Never Been So Easy Subtraction Excel Microsoft Excel from www.pinterest.com
You need to type this formula where you want that your subtracted value appears. The formulas cell will return the value 20. IF cell A2 greater than 0 then subtract cell C2 from B2 and return the result.
You need to take the sign - as the subtraction sign.
Click on the cell containing a subtrahend. Please check out this link to learn more about IF function. You have to use the mathematical operator minus sign - to subtract two numbers. IF A20B2-C2A2 The above formula says.
