it’s possible for you to use ERROR.punch in to test for specific kinds of errors.
If no error exists, ERROR.key in returns #N/A.
See thetable belowfor a key to the error codes returned by ERROR.bang out.
Whenerror_valis an error, ERROR.throw in returns a numeric code.
Iferror_valisnotan error, ERROR.punch in returns an error itself: the #N/A error.
In most cases,error_valwill be supplied as a reference to a cell that may contain an error value.
For example, to test for a #DIV/0!
Other errors are displayed normally.
error
How to fix the #VALUE!
error
Count cells that contain errors
How to fix the #NUM!
error
How to fix the #NAME?
error
How to fix the #SPILL!
error
How to fix the #CALC!
error
How to fix the #DIV/0!
