How to handle DIV/0 errors in Web Intelligence

A short and simple post about handling DIV/0 errors.

To handle DIV/0 errors, use the If() and IsError() functions.

IsError() will return a true or false value depending on the item being evaluated. Wrap this with an If() statement and you can evaluate the formula as normal is if it is ok, or return a message to the user if there is an error:

=If(IsError(15/0);”Error in formula”;15/0)

One Response to “How to handle DIV/0 errors in Web Intelligence”

  1. thebenst Says:

    thank You very much :o)


Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: