Microsoft Office Tutorials and References
In Depth Information
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.
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.
The VLOOKUP function and its arguments.
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.
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