How to subtract In Excel

How to subtract In Excel

Microsoft's Excel program allows you to build spreadsheets with mathematical formulas that adjust data according to your instructions on an ongoing basis. You must learn to choose cells and create formulas to perform the programs basic functions. 

2. Open Microsoft excel.

2.   Click on “New” in the “File” option in the Left sidebar and then click on “Create” Button on the right sidebar to make a new Documents.

3.   Notice that the Columns is exist on upper side of the Spreadsheet and started at the left side with “A” and continue indefinitely toward the right.   

4.   Notice that the rows is exist on the left side of the spreadsheet associated with number. They star at the top to bottom with 1 2 3...

5.    Choose any cell on the spreadsheet. The letter at the top (For Example A) and the row number (For Example 1) at the side should be highlighted in a darker color. This indicates the name of the cell according to column and row.

6.    Enter Information in the cell.

7.   Type values into your spreadsheet.

If you are entering a negative number in the cell, place a minus sign before the number.

Create a table that uses columns and rows to organize your data. If you want to do this, leave a line at the top of each column to enter headings for the columns below.

Other popular column headings include name, address,cost, amount payable, description, cost, Obtain Marks, Percentage, Marks,Total Marks, Obta  and amount receivable. 

You may want to place a "Total" column near the end if you want to add or subtract different costs.

8.   Format your cells in the column according to whether they are words  numbers, Date, Currency,Fraction, Scientific, Time, Percentage,  Text, Special and Custom,

Highlight a group of cells by clicking on 1 cell and dragging it with your mouse until you've covered all the desired cells. You can also click on the letter at the top of the column or number at the row, to select an entire column or row.

Right click on the selected cells and click "Format Cells".

9.   Click On “Number” or “Currency” to indicate what value you will want to subtract (I selected the Number) and click OK.

10.    Click On the Save button Frequently Highlighting in the Red Rectangle on the left of Top Or by Short Key (Ctrl+S)

Create a subtraction Formula for single cells.

Click on the cell where you would like to place the answer to your subtraction formula.

For example, you may want to click on a cell in the "Subtract"(Note: TOTAL IS RENAME BY SUBSTRAC) column, or a cell in the column titled "Less Payment Received."

11.    Find the formula bar at the top with the letter “fx”.

And move your Mouse curser to the blank bar while the cell is still selected. 

11.  Enter an equals sign, "=" in the bar.

You can also press the "fx" function button to start the formula. This will load an equal’s sign into your formula bar.

12.  Type in the cells later and number location of the 2^nd(c2) and 10^th (c10)   you would like to use in your subtraction equation.

13.   Press “Enter”  the second number will be subtracted from the Last number.

14.   Type value and information in the cells in the same ways.

15.   Repeat this with individual cells, by clicking each cells individually.

You can also copy formulas for an entire column, if you are choosing to subtract items from the same row. 

Fill out the subtraction formula(=C2-D2) in E2 Cells. Then, highlight those cells and drag them down to the require Cell.

Look for the small box with a plus sign that pops up near the bottom of those cells. Click the arrow and choose "Fill Formatting Only." This will copy the type of formula you have just used, but move the values to the correct vertical row.