Microsoft Office Tutorials and References
In Depth Information
Troubleshooting Formulas
Figure 9.24.
Figure 9.24. When you apply a numeric format, the answers are correct.
When you apply a numeric format, the answers are correct.
Any time you are doing math between two dates, you should plan to change the
format of the result to be either Number or Date, depending on the situation.
TolearnaboutmanyotherusefuldatefunctionsinExcel,see
see
Chapter11 , UsingEverydayFunctions:Math,DateandTime,
and Text Functions .
Troubleshooting Formulas
It is difficult to figure out worksheets that were set up by other people. When
you receive a worksheet from a co-worker, use the information in the follow-
ing sections to find and examine the formulas.
Highlighting All Formula Cells
The first technique to use when examining a new worksheet is to find all the
cells that contain formulas. The following steps identify all the formula
cells in the worksheet:
11. Ensure that you have a single cell selected.
22. Press F5 to display the Go To dialog.
Search JabSto ::




Custom Search