To perform a simple subtraction, use the arithmetic operator (minus sign). For example, if you enter the formula =105 in a cell, the cell will display 5 as the result.
How to add and subtract in same cell in Excel?
You can subtract just as you can add, simply by changing the plus sign to a minus sign in a simple formula. The same concept applies when creating a formula to subtract cell references. You can even use the SUM function to create a number subtraction formula in Excel. 16
What is the addition formula in Excel?
Type = (press the equals key to start writing your formula) Click on the first cell to add it (B2 in this example) Type + (this is the plus sign) Click on the second Cell to add them (A3 in this example)