Excel is a spreadsheet editor from the popular Microsoft Office suite of office applications. It is most often used for inputting, storing, and statistical processing of relatively small amounts of data. In this spreadsheet editor, the user has access to fairly complex mathematical, statistical, logical, analytical functions, and even the simplest addition and subtraction operations are very easy to implement.
Necessary
Microsoft Office Excel spreadsheet editor
Instructions
Step 1
If you need to calculate the difference between two numbers using this spreadsheet editor, click the cell in which you want to see the result and enter an equal sign. If the contents of a cell start with this character, Excel assumes that there is some kind of mathematical operation or formula placed in it. After the equal sign, without a space, type the number to be reduced, put a minus and enter the number to be subtracted. Then press Enter, and the cell displays the difference between the two numbers entered.
Step 2
Modify the procedure described in the first step slightly if the numbers to be subtracted or subtracted should be taken from some other cell in the table. For example, so that cell B5 displays the number 55 reduced from cell D1, click B5, enter an equal sign, and click cell D1. After the equal sign, a link to the cell you specified will appear. You can also type its address manually, without using a mouse. Then enter the subtraction sign, number 55 and press Enter - Excel will calculate and display the result.
Step 3
To subtract the value of one cell from the value of another, use the same algorithm - enter an equal sign, type the address, or click the cell with the value to be decreased. Then put a minus, enter or click the cell with the value to be subtracted and press the Enter key.
Step 4
If you want to create an entire column of cells containing the difference in numbers from other columns in each row of the table, start by creating one such cell in the first row. Do this according to the algorithm described in the previous step. Then move the cursor to the lower right corner of the cell with the subtraction formula and drag it down with the left mouse button to the last row of the table. Excel will automatically change the links in the formulas for each row when you release the left button.
