Difference between revisions of "Documentation/How Tos/Calc: ISERROR function"

Latest revision as of 13:15, 31 January 2024

FUNCTIONS

Tests for any error value.

ISERROR(value)

Returns TRUE if value refers to or evaluates to any error value, including #N/A, and FALSE otherwise.

Use the ISERR function to test for any errors except #N/A.

ISERROR(SQRT(-1))

returns TRUE, because taking the square root of -1 is an error.

ISERROR(C5)

where C5 contains 123, returns FALSE, because 123 is not an error.

ISERROR(NA())

returns TRUE, because NA() returns the #N/A error.

CHOOSE(0;"A";"B";"C";"D") returns Err:502 (correctly - the index is out of range) but ISERROR(CHOOSE(0;"A";"B";"C";"D")) also returns Err:502, rather than TRUE. The error is propagated rather than evaluated.

See Also

@@ Line 1: / Line 1: @@
-__NOTOC__
+{{DISPLAYTITLE:ISERROR function}}
+{{Documentation/CalcFunc InformationTOC
+|ShowPrevNext=block
+|PrevPage=Documentation/How_Tos/Calc:_ISERR_function
+|NextPage=Documentation/How_Tos/Calc:_ISEVEN_function
+}}__NOTOC__
 == ISERROR  ==
@@ Line 14: / Line 19: @@
 === Example: ===
 <tt>'''ISERROR(SQRT(-1))'''</tt>
-: returns <tt>'''TRUE'''</tt>, because taking the squareroot of -1 is an error.
+: returns <tt>'''TRUE'''</tt>, because taking the square root of -1 is an error.
 <tt>'''ISERROR(C5)'''</tt>
@@ Line 25: / Line 30: @@
 * <tt>'''CHOOSE(0;"A";"B";"C";"D")'''</tt> returns <tt>'''Err:502'''</tt> (correctly - the index is out of range) but  <tt>'''ISERROR(CHOOSE(0;"A";"B";"C";"D"))'''</tt> also returns <tt>'''Err:502'''</tt>, rather than <tt>'''TRUE'''</tt>. The error is propagated rather than evaluated.
-{{Documentation/SeeAlso|
+{{SeeAlso|EN|
 * [[Documentation/How_Tos/Calc: ISERR function|ISERR]]
 * [[Documentation/How_Tos/Calc: ISNA function|ISNA]]