- 1). Click a cell in an Excel spreadsheet and type the equal sign (=). This notifies Excel that you are inputting a math formula.
- 2). Type the value that you will be subtracting from, or click the cell containing the value that you would like to use. Notice that when you click a cell, a dotted line appears around it.
- 3). Type the minus sign (-).
- 4). Type the value that you would like to subtract from the first value, or click another cell. Notice that this cell now has a dotted outline, while the first cell (if applicable) remains highlighted in blue.
- 5). Press "Enter." Excel completes the calculation automatically.
SHARE