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 |