Microsoft Office Tutorials and References

In Depth Information

**Formulas Versus Values**

Because of the record-oriented nature of spreadsheets, you can generally

build a formula once and then copy that formula to hundreds or thousands

of cells without changing anything in the formula.

Formulas Versus Values

Formulas Versus Values

When looking at an Excel grid, you cannot tell the difference between a cell

with a formula and one that contains numbers. To see if a cell contains a

number or a formula, select the cell. Look in the formula bar. If the formula

bar contains a number, as shown in
Figure 8.1
, you know that it is a stat-

ic value. If the formula bar contains a formula, you know that the number

shown in the grid is the result of a formula calculation (see
Figure 8.2
)
. Keep

in mind that formulas start with an equal sign.

Figure 8.1.

Figure 8.1.
The formula bar reveals whether a value is a static number or a

The formula bar reveals whether a value is a static number or a

calculation. In this case, cell E2 contains a static number.

calculation. In this case, cell E2 contains a static number.

Figure 8.2.

Figure 8.2.
In this case, cell E2 contains the result of a formula calcula-

In this case, cell E2 contains the result of a formula calcula-

tion. A formula starts with an equal sign.

tion. A formula starts with an equal sign.

Entering Your First Formula

Your first formula was probably a SUM function, entered with the Quick

Analysis tool or the AutoSum button. However, this discussion is talking