Ask a question »

Basic Excel Formulas

June 2015

Excel is one of the most commonly used applications from the Microsoft Office package. Excel gives users the flexibility to play around with data and do very basic arithmetic operations like addition, subtraction, multiplication or division. One has the flexibility to choose either shortcuts or use custom formulas to do the same. The formulas give the user the option to combine multiple arithmetic operations and derive the results in one go. The use of formulas not only makes the process more efficient but also more intuitive for users who are mathematically inclined.

Basic Excel Formulas


This document lists out some of the basic formulae used in Microsoft Excel.
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.

Below are some basic formulae for Microsoft Excel:
Basic formula :
ADDITION cell A1 to A10 = sum (A1: A10)
  • AVERAGE cell A1 to A10 = average (A1: A10)
  • MAXIMUM cell A1 to A10 = max (A1: A10)
  • MINIMUM cell A1 to A10 = min (A1: A10)


On an Excel sheet, there are many formulas under the cells all over the sheet. You can however select them from a column by doing this:
sum = (A1, A3; C4)

IF Function:

The IF function is very easy to use and can be extremely useful:

= IF (condition; value "if true"; value "otherwise") 


Example:

IF(A1 <= 0; "ordering", "stock")
This would mean: If the contents of cell A1 is less than or equal to zero, then it displays "to order", otherwise (if the contents of cell A1 is greater than zero) it will display "at stock".


Freeze a cell:

Once the cell is written, press F4 to see the details of the cell and dollars.
For unlimited offline reading, you can download this article for free in PDF format:
Basic-excel-formulas.pdf

See also

In the same category

Fórmulas básicas en Excel
By Carlos-vialfa on November 10, 2008
Formules Excel de base
By dogfriend on December 19, 2007
Fórmulas básicas do Excel
By pintuda on April 9, 2010
Original article published by dogfriend. Translated by netty5. - Latest update by Jeff
This document entitled « Basic Excel Formulas » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.