Click on the cell containing a minuend (a number from which another number is to be subtracted).In the cell where you want to output the difference, type the equals sign (=) to begin your formula.You do not necessarily have to type cell references manually, you can quickly add them to the formula by selecting the corresponding cells. The basic Excel subtraction formula is as simple as this:įor example, to subtract the number in B2 from the number in A2, use this formula: To perform a simple subtraction operation, you use the minus sign (-). Subtraction formula in Excel (minus formula)įor the sake of clarity, the SUBTRACT function in Excel does not exist. Subtract text of one cell from another cell.Now, let's take a look at how you can do all this. You can even subtract matrices, text strings and lists. What kind of things can you subtract in your worksheets? Just any things: numbers, percentages, days, months, hours, minutes and seconds. Subtraction is one of the four basic arithmetic operations, and every primary school pupil knows that to subtract one number from another you use the minus sign. You will also learn how to subtract cells, entire columns, matrices and lists. The tutorial shows how to do subtraction in Excel by using the minus sign and SUM function.
0 kommentar(er)
