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