Skip to Content

How to use ISERROR() or ISNA() in Xcelsius

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.


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

Count(number) = 1

Count(error) = 0

You must be Logged on to comment or reply to a post.
  • ISERROR() does now work with the following version/build:


    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!