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.
Search JabSto ::




Custom Search