Subtracting in Excel

Subtracting in Excel

If you are trying to subtract numbers while in Excel, you first need the equals sign = and place – (minus) between two or more values. We can call this a formulas and particular and care needs to be taken when entering it. Order is everything. When it comes to Excel formulas there a few things you need to remember:
In order to complete the formula, you must hit Enter or Tab on the keyboard

Subtracting in Excel

To know how to add Columns and Rows to a Table in Excel, click at http://www.whiskydemalta.com/add-columns-rows-table-excel/

Refer to Cells rather than numbers

One option is to enter numbers directly into a formula but a better and more preferred way is to enter your data into the worksheet cells and then use the references of those cells for your formula.

Subtracting in Excel

The benefit to using references instead of raw data, is because you may need to change the data at a later time and it is easier to do. You simply replace the information and it is transferred to the formula without having to re-write the entire thing. Everything is done more automatically and efficiently this way. You may also choose to mix raw data and cell references, which is also completely acceptable (as in row 4 of the example). To read more information about Excel 2016 click here

Using Brackets when dividing

We all remember that from math class that order needs to be followed when summing/dividing/multiplying. Similarly, Excel also has an order of operation when evaluating equations to determine which part of the formula to solve first. Orders of operation can be altered by simply adding brackets (parenthesis):

Subtracting in Excel