There is not an easier way that I know of, but what I do is type the formula
first to make sure it works, then add the if(iserror( and shift end ctl+c to
copy the formula i typed, add the ,"", and ctl+v to paste formula )) and
thats it, i NEVER retype known working code/functions too much oppurtunity
for error as you mentioned.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Idoia" wrote:

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!