Subraction (Minus)
There's no SUBTRACT function in Excel. for such as a minus for subtract (-), All formulas in Excel must begin with an equals sign (=)
Function =A1-A2
The formula above subtracts the value in cell A2 from the value in cell A1.
Formula =A1-A2-A3-A4-A5-A6
Multiple arguments must be separated by a subtract (-) symbol. For example: =A1-A2-A3-A4-A5-A6 will add the values of all the cells in the six arguments.
These values can be numbers, cell references.
Direct Subtraction
-
Type the equal sign, and then type a few numbers that are separated by a minus sign (-).
-
For example, =50-10-5-3.
-
Press RETURN .
If you use the example numbers, the result is 32.
Related Topics
=> Introduction of Excel=> User Interface
=> The Excel Interface: Application Window
=> The Excel Interface: The Workbook Window
=> Creating, Opening and Exporting Workbook and Compatibility mode
=> Understanding Cell, Cell content
=> Modify Row, Colums and Cell, Wraping text and Merging text
=> Excel Shortcut Key
=> Home Tab: Clipboard Font Formatting, Text Alignment
=> Home Tab: Number, Styles, Cell, Editing
=> Addition and the SUM Function
=> Subraction (Minus)
=> Multiply and PRODUCT Function in Excel
=> Divide or Division
=> Reminder in Excel
=> Max Function in Excel
=> Min Function in Excel
=> Average Functions
=> Count Functions
=> Counta Function
Related Topics
=> Introduction of Excel=> User Interface
=> The Excel Interface: Application Window
=> The Excel Interface: The Workbook Window
=> Creating, Opening and Exporting Workbook and Compatibility mode
=> Understanding Cell, Cell content
=> Modify Row, Colums and Cell, Wraping text and Merging text
=> Excel Shortcut Key
=> Home Tab: Clipboard Font Formatting, Text Alignment
=> Home Tab: Number, Styles, Cell, Editing
=> Addition and the SUM Function
=> Subraction (Minus)
=> Multiply and PRODUCT Function in Excel
=> Divide or Division
=> Reminder in Excel
=> Max Function in Excel
=> Min Function in Excel
=> Average Functions
=> Count Functions
=> Counta Function
