It may depend on the complexity of the expression but would making the
expression a named formula help? Then you can put:

If (isna(NamedFormula),0,NamedFormula)

Regards

Sandy

--
to e-mail direct replace @mailinator.com with @tiscali.co.uk


"xirx" <xirx@gmx.de> wrote in message
news:423a069f$0$4362$4d4ebb8e@read.news.de.uu.net...
>
> Is there a way to avoid the use of some-complex-expression in
> thix formula?
>
> if(isna(some-complex-expression); 0; some-complex-expression)
>
> In some programming languages, 0 means false and any other
> value means true and the OR(X,Y) actually means: if(X;X;Y).
> Thus, you can use the OR as a shortcut for this if-statement
> and avoid notation and evaluation of X, twice.
>
> But Exel's OR returns TRUE or FALSE...
>
> So: Is there any way to shorten
>
> if(isna(some-complex-expression); 0; some-complex-expression)
>
>
>