Excel – Formulas (Simple)

Excel can be used to calculate and analyze numerical information; however, you will need to know how to write formulas to maximize Excel’s capabilities.  A formula is an equation that performs a calculation using values in the worksheet. In this lesson you will learn how to create simple formulas using mathematical operators such as the addition, subtraction, multiplication, and division signs.

Sample Worksheet

Excel 2007-Creating Simple Formulas-Sample Worksheet_Budget

Handouts

Excel 2007 GCF – Creating Simple Formulas

Or, click this link: http://www.gcflearnfree.org/excel2007/5.1

Operators

Using Operators to enter calculations. Basic Operators include:

Addition (+)

Subtraction (-)

Division (/)

Multiplication (*)

Using Cell References In Formulas

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.

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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s