|
Excel: Work Smarter
Conditional Logic: IFERROR
The IFERROR function is used to determine if
there are any problems with the data. Here are a few of the problems
that can be calculated:
#N/A (not enough data),
#VALUE! (different data types, such as adding a
number to a date),
#REF! (a lost cell reference),
#DIV/0! (a divide by zero error), #NAME? Where's the
Named Range), or #NULL!. (an empty cell with no data).
Before You Begin: Select cell H2 and delete the data.
This sample will test for empty, or #NULL values.
Try This: The IFERROR Function
Select: Cell H6.
Go to
Formula -> Logical
->IFERROR
Value: H2=0
Value_if_error: "No Data Available" The
formula in this example is:
=IFERROR(H2=0,"No Data Available") Formula -> Logical
->IFERROR |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 3. Creating and Modifying Formulas
3.6. Use conditional logic in a formula 3.6.1. Using IF, AND, OR, NOT, IFERROR