Subtraktion in Microsoft Excel

Subtraction in Excel allows you to take values ​​away from each other.
The minus sign is used for the calculation -.

Entering a formula in Excel always begins with the equals sign =.

Example of a simple subtraction

=10-5

Result:5

Excel automatically calculates the difference between the two numbers.

Subtraction with cell references

Often, cell references are used instead of direct numbers.

Example:

=A1-B1

The value from cell A1 is subtracted from the value in cell B1.

Everyday example

Subtraction is frequently used for:

• Income minus expenses
• Inventory minus products sold
• Working hours minus break time
• Budget minus Cost

Example:
If cell A1 contains the income and cell B1 contains the expenses, the remaining amount can be calculated using a formula.

Advantages of subtraction in Excel

• fast calculations
• automatic update of results
• fewer calculation errors
• simple data analysis

Subtraction is one of the most important basic functions in Microsoft Excel and is used in many spreadsheets.