## 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