More complicated problems need a good understanding of how Excel handles order of operations. After youve typed the equal sign type the numbers youre subtracting separated by the minus sign -. The above formula says.
IF cell A2 greater than 0 then subtract cell C2 from B2 and return the result.
In the cell where you want to output the difference type the equals sign to begin your formula. A step-by-step example of creating a subtraction formula in Excel using point and click. For example the formula below subtracts numbers in a cell. Dont forget always start a formula with an equal sign.