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