Replace formula with IF(error(formula;"";formula)
Hi all
Do you think is there any macro that can change the formula in selected
range to include the IF-iserror so no error appears on the screen?
For example:
In cell A1 the formula is: =A2+B2
But if I select A1 and run the macro, It would change to:
=IF(ISERROR(A2+B2);"";(A2+B2))
I need that beacause I have a sheet with lots of formulas with different
errors and It would be quite painful to chang every formula.
Thanks you for your help!!!!
|