If youre completely new to Excel you can learn how to create simple formulas in our completely free Basic Skills course. Number 1 is subtracted by the percentage discount. The formula below subtracts the value in cell A2 and the value in cell A3 from the value in cell A1.
You have to use the mathematical operator minus sign - to subtract two numbers.
The same concept holds true when you create a formula for subtracting cell references. Type the equal sign into cell D3 to begin the formula. Improve Formulas with Cell References. Lets take an example of a simple formula.