Library Home page | Library Catalog
Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

Microsoft Office 2010: Functions & Formulas

About Formulas

About Formulas
1. Formulas are equations that perform calculations on values in your worksheet. A formula starts with an equal sign (=). For example the following formula multiplies 2 by 3 and then adds 5 to the result:                 

Simple Formula: =A5+B2*C3; =A2/B3
1. Refer to the cell itself when creating formulas (which will pull the values   contained within the cell). That way, if a value changes in a cell, the answer to the formula changes with it.

+ means Add e.g. A2+C2 Add the value (number) in cell A2 to the value (number) in cell C2
- means Subtract e.g. A2-C2 Subtract the value (number) in cell C2 from the value (number) in cell A2
* means Multiply e.g. A2*4 Multiply the value (number) in cell A2 by 4
/ means divide e.g. A2/3 Divide the value (number) in cell A2 by 3


1. Functions are used for working with long lists of numbers and are ready-made formulas. A function may look like this: =SUM(A3:A30); =AVERAGE(A3:A30); =PRODUCT(A3:A30)
2. The colon : separates the first cell in the list from the last cell in the list.

=SUM(B3:B9) Adds the list of values from cell B3 to cell B9
=AVERAGE (B3:B9) Averages the values from cell B3 to cell B9
SUM adds the numbers in the list
AVERAGE averages the numbers in a list
PRODUCT multiplies the numbers in a list
MAX indentifies the highest number in the list
MIN identifies the lowest number in the list
COUNT counts the number of numerical items in a list

1. Navigate to Home Tab within your Excel workbook and then to the Editing group
2. From the Editing group, select the icon for AutoSum (sigma icon)

3. The AutoSum will add the numbers in a list within a single row or column