IFERROR
- Juliane Wetzel
Owned by Juliane Wetzel
Feb 07, 2020
Loading data...
Syntax
IFERROR(possibleError:<Any>;replacement:<Any>)
Description
IFERROR returns a value that specifies if a formula evaluates to an error.
- if the expression in 'possibleError' is an ERROR value, then 'replacement' is returned, otherwise the value of 'possibleError' is returnedÂ
- both, 'possibleError' and 'replacement', must have the same type
- if 'replacement' is also an ERROR, then that error value will be the result of IFERROR
Example
IFERROR(#B;100)
| A | B | IFERROR |
|---|---|---|
| 0 | <error> | 100.0 |
| 1 | 5.0 | 5.0 |
| 2 | 2.5 | 2.5 |
| 3 | 1.666 | 1.666 |
| 4 | 1.25 | 1.25 |