Reading Basic formula from excel sheet

Hello Friends!

I am going to show how can you add or read some basic formulas from excel sheet.

Reading formula from excel is little tricky but not complex. πŸ™‚

First thing is any cell in excel can contain formula; it’s not that easy to figure out exactly which sell consist of formula.

You need to navigate to all cell and check formula bar.

Please check below screenshot – The first highlight part is CELL ADDRESS and second is FORMULA BAR

I will show SUM, SUBTRACT, MULTIPLY, DIVIDE and AVERAGE function.


1). Add Function

Function is :

=SUM(A2:B2) 

where A2 and B2 is the address of the cell you want to add.

C2 show result. And same thing C3 and C4 does for their particular cell.


2). Subtract Function

Function is :

=A8-B8

where A8 and B8 is the address of the cells you want to subtract

C8 shows result of subtract. And same happens to C9 for their particular cells.


3. Multiply

Function is :

=A12-B12

where A12 and B12 is the address of the cells you want to multiply. While C12 shows result.

C13 shows multiplication of decimal numbers.


4. Divide

Function is

=A16/B16

where A16 and B16 is the address of the cells you want to divide. While C16 shows divide result.

C17 and C18 shows result of tricky digits.


5. Average

Function is :

AVERAGE(C2:C4)

where C2 and C4 is there to get average of C2, C3 and C4. So C2:C4 is showing range from C2 to C4.

C5 shows Average result.

There are many more useful functions as well; will focus on them soon.

Thank You. Stay Updated. πŸ™‚

Blog Catagory : Excel