![]() ![]() To subtract multiple cells from the same cell, you can use any of the following methods. ![]() How to subtract multiple cells from one cell in Excel Press the Enter key to complete your formula.Īnd you will have a result similar to this:.Click on the cell containing a subtrahend (a number to be subtracted) to add its reference to the formula (B2).Its reference will be added to the formula automatically (A2). 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. ![]() For example, to subtract the number in B2 from the number in A2, use this formula: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |