ELIMIKA BLOG
Live
wb_sunny

Breaking News

Excel basic formula

Summation in Excel

The basic way of adding things is 
=A1+B1+C1

Or the use of in built formula
=Sum(A1:C1)

Adding non consecutive cell
=Sum(A1:C1)+D8

Or
=Sum(A1:C1,D8)
Another some function
=Sum(A1:C1)+=Sum(A4:C4)

Substraction in excel
Simple method of substraction is 
=A2-C4
Multiplication in excel
=A2*C2

Multiply more than two numbers
A2, B2,C3
Put semi colone notation(:)
=Sum(A2:C3)
Or use product sign
=Product (A2:C3)

Division in Excel
Division of one value to another the slash sign should be used as follows
Take example A2 is filled by 40 and A3 is filled by 10
=A2/A3
The answer is 4
Average in Excel
Here, you are trying to figure a common value. Example of determine the students score marks to all exams lets see these three subjects average

Insert this formula to Average cell E2 as follows
=Average (B2:D2)
Or use average function in function library