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) 
  2. Vijay Mohan

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

    (0) 

Leave a Reply