Creating formulas to subtract values in Excel is straightforward to start with, but as you can see it has some advanced uses. Getting to grips with basic math in spreadsheets can help you make the ...

To subtract the cells B1, C1, D1, and E1 from cell A1, you have to write the following formula in the cell in which you want to display the result and press Enter.

Excel provides two options for calculating the difference between two times. If you use a simple subtraction operation such as "=C1-A1," select the custom format "h:mm" from the Format Cells options.

Subtracting isn’t as straightforward in Excel as it seems, simply because there’s no actual command to subtract numbers. Instead, you have to use a formula with the subtraction operator.

In cell C3, I’ve entered a simple subtraction formula that calculates the difference between these two times to be 10.41666667, which equates to 10 days and 41.666667% of an additional day. You can ...

It signals to Excel that what follows is a formula, not plain text. + (Plus): Used for addition, this symbol allows you to sum numbers or cell values with ease.