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




Custom Search