# Excel formula- free online course excel

**Excel formula | Learn excel formula | how to use excel formula | how to insert excel formula | best formula in excel**

**What is excel formula?**

Excel formula is expression that operates on values in a range of cells or within one cell.

**What are uses of excel formula?**

Formulas in excel are used to operate mathematical calculation such as

- summation
- subtraction
- multiplication
- division

**Syntax in excel**

Syntax is the rules that define the combination of symbols that are considered to be correctly structured statement or expressions

Or syntax is a form of code that provide a meaning after being written correctly

**Syntax of formula in excel**

A formula in excel start with the equal sign = typed in a cell.

let's check example below of different formula

**1. Summation in Excel**

i. The basic way of adding is

**Example of summation formula**

__=Sum(A1:C1)__

The word sum means summation

The difference between inbuilt formula and basic way of adding is this. in basic way of adding excel can add different cell that located at different location in a workbook such as adding of A2, C3, B5 because only plus sign is used to add different cells

**while**

inbuilt formula adds consecutive cells ( cells that followed one another like A1,B1,C1 Or A1, A2, A3)

**Example of inbuilt formula**

iii. Adding non consecutive cell

=Sum(A1:C1)+D8

This is used to add consecutive followed by non consecutive cell to do so after completing consecutive cell close with blanket and add + sign to add non consecutive cell or use comma to close both cells in blanket as shown below

Or

=Sum(A1:C1,D8)

Another sum function

=Sum(A1:C1)+=Sum(A4:C4)

This is used to add two different groups of consecutive cells

**2. Subtraction in excel**

Simple method of subtraction is

=A2-C4

**3. 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)

**4. 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**

Average formula in excel

__=Average (B2:D2)__Or use average function in function library