Microsoft Office Tutorials and References
In Depth Information
Automatically Formatting Formula Cells
Figure 9.16.
Figure 9.16. Cutting the precedent cells from cell C7 causes the formula in
Cutting the precedent cells from cell C7 causes the formula in
C7 to change to reflect the new location.
C7 to change to reflect the new location.
Automatically Formatting Formula Cells
The rules for formatting the result of a formula seem to be inconsistent.
Suppose that you have $1.23 in cell A1. All cells in the worksheet have the
general format except cell A1.
If you enter =A1+3 in another cell with general format, the result automat-
ically inherits the currency format of cell A1, as shown in Figure 9.17 .
Search JabSto ::




Custom Search