Microsoft Office Tutorials and References

In Depth Information

**Creating a Simple Formula**

Creating a Simple Formula

A
formula
calculates values to return a result. On an Excel worksheet, you can create a

formula using values (such as 147 or $10.00), arithmetic operators (shown in the table),

and cell references. An Excel formula always begins with the equal sign (=). The equal

sign, when entered, automatically formats the cell as a formula entry. The best way to start

a formula is to have an argument. An
argument
is the cell references or values in a for-

mula that contribute to the result. Each function uses function-specific arguments, which

may include numeric values, text values, cell references, ranges of cells, and so on. To ac-

commodate long, complex formulas, you can resize the formula bar to prevent formulas

from covering other data in your worksheet. By default, only formula results are displayed

in a cell, but you can change the view of the worksheet to display formulas instead of res-

ults.

Enter a Formula

Click the cell where you want to enter a formula.

Type = (an equal sign). If you do not begin with an equal sign, Excel will dis-

play, not calculate, the information you type.

Enter the first argument. An argument can be a number or a cell reference.

Timesaver

To avoid typing mistakes, click a cell to insert its cell reference in a for-

mula rather than typing its address.

Enter an arithmetic operator.