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. π