Adding "IFERROR" with substitute formula:

[valmir]

Hello everyone:
In cell I3, I have this formula:

=I4-I5

In cell J3 I want to use a substitute formula to turn the cell in I3 into this:

=IFERROR(I4-I5;"")

I tried this:

=SUBSTITUTE(I3; "="; "=IFERROR(") & ';"")

But it's giving me a "not a formula?" error.
Any solution? Or any other solution to automatically replace formulas with "iferror"?

 

[Joe4]

That is not a valid formula.
I don't think you can use the SUBSTITUTE function on formulas. I believe it works on the values being returned by the formulas, not the underlying formulas.
If you want to change the formulas, you would either need to use the Find/Replace functionality, or VBA.

But why do you need a formula to change it?
Why not just re-type the formula the way you want?
If it covers a multi-cell range, you should just be able to copy/auto fill the rest of the range after your fix the first one.

 

[valmir]

That is not a valid formula.
I don't think you can use the SUBSTITUTE function on formulas. I believe it works on the values being returned by the formulas, not the underlying formulas.
If you want to change the formulas, you would either need to use the Find/Replace functionality, or VBA.

But why do you need a formula to change it?
Why not just re-type the formula the way you want?
If it covers a multi-cell range, you should just be able to copy/auto fill the rest of the range after your fix the first one.

Thanks for the explanation. I couldn't think that far...

 

[Joe4]

Note, if you wanted a separate formula in J3, leaving formula I3 alone, you could just put this in J3:

=IFERROR(I3,"")

which I think will get you the result you want.