IFERROR

Returns value if no error, otherwise alternate.

Excel: Verified match
Google Sheets: Verified match
Returns: Any value

Examples

=IFERROR(A1/B1, 0)

	A	B
1	10	2

Result 5

Syntax

IFERROR(value, value_if_error)

value: any required
value_if_error: any required

Errors

#ERROR!: =IFERROR(1,2,3)

ANDReturns TRUE if all arguments are true. EQTrue when two values are equal. FALSEReturns the logical value FALSE. GTTrue when the first number is greater. GTETrue when the first number is greater or equal. IFReturns one value if condition is true, another if false.