Hello,

I need the result of a cell to show zero or blank if the result of my
formula is an error.

The easy way to do it is like tihs, which generally works fine:

=IF(ISERROR(formula),"",formula)

My problem is that my "formulas" sometimes include the RAND() function, so
the evaluation of the first part is not necessarily the same as the second
part. Also, for long formulas, it gets cumbersome and leads to more errors
having to enter them twice.

Is there a simplified way to achieve this, without having to type the
formula twice, and without having to use an extra cell?

Thanks!