Basic Excel Formulas

July 2016


Microsoft Excel gives users the flexibility to configure data and do very basic operations such as addition, subtraction, multiplication, or division by utilizing shortcuts or custom formulas.

This article will introduce some of Excel's most basic formulas. Note that when using this functionality in Microsoft Excel, each cell must include the = sign before your formula.


Basic Formulas on Microsoft Excel

Addition Formula

If you'd like to find the sum of your data data in rows A1 to A10 in your spreadsheet, you may do so by using the following formula:

=SUM(A1: A10)

If you are looking to add data in cells that are not juxtaposed, you may do so by simply typing =SUM and clicking directly on the cells you'd like to include. Make sure that the cells listed are surrounded by parenthesis (i.e. =SUM(A1, A3; C4)).

Average Formula

If you'd like to find the average of your data in rows A1 to A10 in your spreadsheet, you may do so by using the following formula:

=Average(A1: A10)

Maximum and Minimum Formula

These two formulas may be used to find the maximum and minimum numbers of data points located in rows A1 to A10 in your spreadsheet:

=Max(A1: A10)

=MIN(A1: A10)

The IF Function

The IF function may be used to apply a condition to your data. For example, if a manager would like to be notified when stock on a product reaches zero, he may use this function to program a custom notification to appear in an adjacent cell. This sort of formula would look like this:

IF(A1 <= 0; "ordering", "stock")

In this case, if the contents of cell A1 is less than or equal to zero, the words "to order" will appear in an adjacent cell. If the contents of cell A1 is greater than zero, the column will read "in stock."

A more general IF function would look like this:

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

Freeze Cells in Excel

Once the cell is written, press F4 to see the details of the cell and dollars.

See also :

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.