Skip to main content

Microsoft Office: 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

Source: webjunction.org


 
Functions
1. Functions are used for working with long lists of numbers. 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



AutoSum
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