# Using Formulas and Functions

- 6/15/2010

- Understanding Formulas and Cell References in Excel
- Creating Simple Cell Formulas
- Assigning Names to Groups of Cells
- Using Names in Formulas
- Creating a Formula That References Values in an Excel Table
- Creating Formulas That Reference Cells in Other Workbooks
- Summing a Group of Cells Without Using a Formula
- Creating a Summary Formula
- Summing with Subtotals and Grand Totals
- Exploring the Excel Function Library
- Using the IF Function
- Checking Formula References
- Debugging Your Formulas

## Creating Simple Cell Formulas

Building calculations in Excel is pretty straightforward. If you want to find the sum of the values in two cells, you just type an equal sign (=), the reference of the first cell, a plus sign (+), and the reference of the second cell. The formula you enter appears on the formula bar, where you can examine and edit it.

### Build a Formula

Click the cell in which you want to enter a formula.

Type =.

Type the expression representing the calculation you want to perform.

Press Enter.

### Edit a Formula

Click the cell you want to edit.

Select the part of the formula you want to edit in the formula bar.

Make any changes that you want.

Press Enter.