Hello everyone:
In cell I3, I have this formula:
In cell J3 I want to use a substitute formula to turn the cell in I3 into this:
I tried this:
But it's giving me a "not a formula?" error.
Any solution? Or any other solution to automatically replace formulas with "iferror"?
In cell I3, I have this formula:
Excel Formula:
=I4-I5
Excel Formula:
=IFERROR(I4-I5;"")
Excel Formula:
=SUBSTITUTE(I3; "="; "=IFERROR(") & ';"")
Any solution? Or any other solution to automatically replace formulas with "iferror"?