IFERROR Function (LibreOffice Calc)
Learn the IFERROR function in LibreOffice Calc: Returns value if not an error value, else alternative.
The IFERROR function in LibreOffice Calc is used for this task: Returns value if not an error value, else alternative. Replace a calculation error with a readable message.
This guide explains how to read the formula, reproduce a concrete example, interpret its result and recognize common input mistakes.
Syntax and arguments
IFERROR(value; alternative_value)
| Argument | Required? | Meaning |
|---|---|---|
Value |
Yes | The value to be calculated. |
Alternative value |
Yes | The alternative to be returned, should value be an error value. |
Calc formulas normally use semicolons (;) between arguments in common configurations; the displayed separator may depend on settings or locale.
Worked example
=IFERROR(1/0;"Check value")
Expected result: Check value.
Why it works: Replace a calculation error with a readable message.
How to use it in your own spreadsheet
- Identify the cells or inputs that correspond to the sample values above.
- Enter the formula in an empty cell, changing the references or literal values to match your sheet.
- Compare the output with a manual check on a small known example.
- Extend the formula to a larger dataset only after you understand the result.
Common problems and practical checks
- Be explicit about the difference between TRUE/FALSE, zero, blank cells and text values.
- Consider how errors are handled instead of automatically suppressing them.
- A pasted formula may produce an error when it uses the other program’s argument separator or unsupported options.
Related functions
Documentation and verification
- LibreOffice Calc Help
- The standalone example was calculated using LibreOffice Calc 25.2.3.2 on October 9, 2026 and its computed result matched the expected value. This does not certify every option, version, or other example.