Replacing ISERROR Formula
 

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

--
Ismael R

Replacing ISERROR Formula
 

Try this:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ismael R" wrote in message
...
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))

--
Ismael R

Replacing ISERROR Formula
 

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


--
Biff
Microsoft Excel MVP


"Ismael R" wrote in message
...
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))

--
Ismael R

Replacing ISERROR Formula
 

Thanks Biff. the formula worked!
--
Ismael R


"T. Valko" wrote:

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


--
Biff
Microsoft Excel MVP


"Ismael R" wrote in message
...
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))

--
Ismael R

Replacing ISERROR Formula
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Ismael R" wrote in message
...
Thanks Biff. the formula worked!
--
Ismael R


"T. Valko" wrote:

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


--
Biff
Microsoft Excel MVP


"Ismael R" wrote in message
...
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))

--
Ismael R

Replacing ISERROR Formula
 

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

Replacing ISERROR Formula
 

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

On Thu, 5 Mar 2009 11:46:01 -0800, Sam
wrote:

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