Skip to Content

The fact that Xcelsius does not implement either ISERROR() or ISNA() is of much frustration to many of us – these are indispensable functions when used in conjunction with error-prone functions such as FIND() or MATCH().

 

Thankfully, there is a work around!

Just use Count()

Say $A$1 is a string: A1 = “hi, world!”

And you want to know if A1 includes the word “hello”.  In Excel, you would simply do B1 = IFERROR(FIND(A1,”hello”),””)

  

But that won’t work in Xcelsius.  Instead, use

B1 = COUNT(FIND(A1,”hello”))

which will return 0 if “hello” is not found, and 1 if it is found.

Summary

So if you want to use errors in formulas, use Count() instead of iserror():

Count(number) = 1

Count(error) = 0

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Jason Olson

    ISERROR() does now work with the following version/build:

    Version: 6.0.5.0

    Build: 14,0,5,882

    I’m not sure when exactly that support came in but I can confirm that it works with the mentioned version at least.

    The COUNT is certainly a nice alternative though and for anyone that is not on a more recent version it may be the only approach. Thanks for sharing!

    (0) 

Leave a Reply