How to apply Basic Formulas in Excel (Sum, Subtract, Multiply, Divide)

Sum:

In expense sheet, we have to calculate that how much expense we had in the month of Jan-2010.sum formula in excel sheet

Method 01: Write down the Formula: =Sum(B3:B8) in resulting cell.

From B3 in which B=Column, 3=Row

To B8 in which B=Column, 8=Row

02

 

Method 02: Write down “=Sum(“ in resulting cell. Click on the first cell, move to the bottom right corner of the cell. When“two sided arrow”sign appears, drag to the last cell.

03

 

You do not need to apply formula on each cell separately, Go to the formula cell and move to bottom right corner of the cell. You will see “plus sign, excel, drag sign” sign. Hold and drag to the cell in which you wish to apply the same formula.

04

 

See if you have applied correct formula, Select the cells and see on the bottom right corner of the sheet.

05

 

Subtract:
For subtraction, Write down the formula =Sum(B2-B-11) Or Write down “=Sum(“, Select first cell, put dash (-) and Select other cell you want to subtract from the first)

06

 

Multiply:
For multiplication of two or multiple cells, Write down the formula =(B3*D3) Or write down “=“, Select first cell, put “*” sign and Select other cell you want to multiply with.

07

 

Divide:
For Division between two cells, Write down the formula =(B3/D3) Or put “=” sign, Select first cell, put “/” and select the other cell you want to divide on.

08

 

Be the first to comment

Leave a Reply

Your email address will not be published.


*