![]() This might seem counterintuitive since the SUM function is usually used to add values, but it can also be used to subtract. Subtracting in Excel using the SUM functionĪnother way to subtract in Excel is by using the SUM function. For example, if you want to subtract the value in cell A1 from the value in cell B1, you would enter “=B1-A1” in the cell where you want the result to appear. To subtract one value from another, you simply need to enter the two values in two cells, select the cell where you want the result to appear, and type the formula “=cell1 – cell2” (without the quotes). The simplest way to minus in Excel is by using the minus sign (-). Subtracting in Excel using the minus sign (-) What if the values I want to subtract are in different worksheets?. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |