# Microsoft Office 2010: Functions & Formulas

## About Formulas

**About Formulas **

1. * Formulas* are equations that perform calculations on values in your worksheet.

*. For example the following formula multiplies 2 by 3 and then adds 5 to the result:*

**A formula starts with an equal sign (=)****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 and are ready-made formulas*. A function may look like this:

*; =AVERAGE(A3:A30); =PRODUCT(A3:A30)*

**=SUM(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

*(sigma icon)*

**icon for AutoSum**

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

** **

** **