Creating Pixel-Perfect Reports > Getting Started with the Reports Tool in the Desktop Application > Building Report > Adding a New Sheet and Working with It > Working with Report Sheet Data > Using Formulas > Function Wizard > Logical Functions > IfError
The function wizard for the IfError function:
IfError(Expression, ValueIfError)
Expression. Expression
ValueIfError. The value if the expression contains error.
It returns the expression if it does not contain error, otherwise it returns the specified value.
Parameter values can include numbers, empty cells, logical values, cell references, formulas.
If a cell range is used, the top left cell value will be used as the returned value.
If the expression range does not contain errors, the top left cell value will be used as the returned value. If the expression range contains at least one error, the specified value will be returned.
| Formula | Result | Description |
| =IfError(J11:K12, J7:K10) | True | Value of the top left cell of the expression range that does not contain errors. |
See also:
Function Wizard │ Logical Functions
