Skip to Content
Author's profile photo Former Member

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.

Summary

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

Count(number) = 1

Count(error) = 0

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jason Olson
      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!

      Author's profile photo Former Member
      Former Member

      Beg to differ. They perfectly work. Only prob is they shoot the memory up quite steep. Minimal number of these functions recommended. 🙂