IFERROR

This function evaluates a formula and returns a value you provide if there is an error or the formula result.

Syntax

IFERROR(value, error)

This function has these arguments:

Argument	Description
value	[Required] Value or expression to evaluate
error	[Required] Value to return if the formula returns an error

The following error types are evaluated, #VALUE!, #REF!, #NUM!, #NAME?, #DIV/0, #N/A, or #NULL

IFERROR(A3/A5,"dogs")