Microsoft Office Tutorials and References
In Depth Information
Troubleshooting Errors
Chapter 9
Working with Formulas and Functions
6. In the first argument box, type the cell
address, actual value, or click on the cell that
contains the argument.
7. Click in the next argument box and repeat the
previous step. As you click in each argument,
Excel displays a description. Repeat until all
required arguments have a cell reference or a
value. Figure 9-23 illustrates the IF function
arguments dialog box and Figure 9-24
illustrates the VLOOKUP arguments dialog box.
Figure 9-23
The IF function and its arguments.
8. Click on OK. The Function Arguments dialog
box will close and Excel displays the function
result in the selected cell.
Figure 9-24
The VLOOKUP function and its arguments.
Troubleshooting Errors
GIGO: Garbage In, Garbage Out.
That’s what happens if you enter incorrect
data into your worksheet. The answers
become garbage and are useless. To help you locate
potential problems, Excel provides a number of tools.
Viewing Formulas
As you’ve already seen, when you create formulas,
the result of the formulas is what Excel displays in
the worksheet. Although the Edit line displays the
actual formula, you can view only one formula at a
time. Excel provides a method to view the formulas
Search JabSto ::

Custom Search