Basic Excel Formulas

If you're getting started with Excel, creating formulas is one of the first things you should learn.
The use of an Excel sheet can be made very simple and efficient if some formulae are incorporated into it. Basic mathematical functions such as addition or finding the maximum and minimum values listed can be used in an Excel sheet. This article shows how these formulae can be implemented while using the Excel sheet.
When entering a formula, you have to make sure Excel knows that's what you want to do. You start by typing the = (equals) sign, then select cells to enter cell adress and type any sign like +,-,*,/ between cell adresses. If you don't type the equals sign first, then Excel will assume you are typing a number. Excel will assume you're typing a formula and insert the equals sign for you. There are four basic formulas:

    Addition (+)
    Subtraction (-)
    Multiplication (*)
    Division (/)

 Excel examples of basic formulas :
=A1+B1
=A1+B1-C1
=A1/B1
In each case, you would type the equals sign (=), then the formula, then press Enter to tell Excel you've finished.You can also type this formula in Formula Bar.

Below are some basic formulae for Microsoft Excel:

    AVERAGE cell A1 to A10 = average (A1: A10)
    MAXIMUM cell A1 to A10 = max (A1: A10)
    MINIMUM cell A1 to A10 = min (A1: A10)