Replacing ISERROR Formula

[Ismael R]

I am trying to use Xcelsius to build some what-if dashboards but Xcelsius
does not support the ISERROR function in Excel. Does anyone know of an
alternaitive for the ISERROR function. Below is a sample of the formule where
I want to replace ISERROR.

=IF(ISERROR(F8/1000),"",(F8/1000))

 

[RagDyer]

Try this:

=IF(ISNUMBER(F8/1000),F8/1000,"")

 

[T. Valko]

An alternative to ISERROR but I have no idea if it's compatible with
Xcelsius:

=IF(COUNT(F8/1000),F8/1000,"")

If F8/1000 = an error, COUNT = 0 and IF returns the value_if_false agument
"".

 

[Ismael R]

Thanks Biff. the formula worked!
--
Ismael R

An alternative to ISERROR but I have no idea if it's compatible with
Xcelsius:

=IF(COUNT(F8/1000),F8/1000,"")

If F8/1000 = an error, COUNT = 0 and IF returns the value_if_false agument
"".

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[Sam]

This is a great formula for a number. Is there any solution for a character
field?

 

[Gord Dibben]

ISERROR should work on text strings.

Do you have an example of how you would like it used or what doesn't work
when you do use it?


Gord Dibben MS Excel MVP