GCFLearnFree.org

This has really aided my job search and created ample opportunities.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2007
  • Creating Simple Formulas

Excel 2007

Single page view print copy

Creating Simple Formulas

Using cell references

As you can see, there are many ways to create a simple formula in Excel. Most likely, you will choose one of the methods that enters the cell address into the formula rather than an actual number. The cell address is basically the name of the cell and can be found in the Name Box.

Select Cell

The following example uses actual numbers in the formula in C5.

Simple Addition Formula

When a cell address is used as part of a formula, this is called a cell reference. It is called a cell reference because instead of entering specific numbers into a formula, the cell address refers to a specific cell. The following example uses cell references in the formula in C30.

Point and Click

previous next
previous 1 2 3 4 5 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.