Create a formula in Excel

Formulas are equations that perform calculations on values ​​in your Excel Work Book.

A formula starts with an equal sign (=). 

1 / create a simple formula

• click in a cell
• then type    = 5 * 6 9
  
• the following formula multiplies 6 by 9 and adds 5 to the result.

2 / create a formula that refers to other cells

Example formula	Effect
= C2	Uses the value in cell C2
= Sheet2! B2	Uses the value of cell B2 on Sheet2

1. Click the cell in which you want to enter the formula.
2. in the formula bar,
   
    
3. type  = (equal sign).
4. then select a cell (or a range of cells, a location on another worksheet ..)
   
5. press enter
6. add a "logical operator" 
   eg +, -, / ...
7. and repeat as often as necessary with other cells