Replacing ISERROR Formula

I

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))
 
T

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
"".
 
I

Ismael R

Thanks Biff. the formula worked!
--
Ismael R


T. Valko said:
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
"".
Click to expand...
 
G

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
 
Top