Radenkovich’s P(a)lace

IsError function is used to check for errors in expressions or cells. At first sight most usefull case when you will need to use this function is to suppress division by zero error automatically. If not, you can always check for #DIV/0! cell by cell - but it would be inappropriate use of all this comfortable technology. This can’t be done without IF function which one is described in previous post on this website right here. You can save lots of your time resources and energy just by using combinations these two functions.

The syntax for the IsError function is:

ISERROR([value])

[value] - value or expression that you want to test. This function will return true for the next list of error values:

• #N/A
• #VALUE!
• #REF!
• #DIV/0!
• #NUM!
• #NAME?
• #NULL

For all other values or expression results IF function will return FALSE.

EXAMPLE

Take a look at this example:
=IsError( #N/A) -> return TRUE
=IsError(#VALUE!) -> return TRUE
=IsError(#REF!) -> return TRUE
=IsError(12345) -> return FALSE
=IsError(”Tech on the Net”) -> return FALSE
=IsError(3/0) -> return TRUE