Forum Discussion
Solved
How to have a cell A equal cell B IFERROR in cell C OR cell D, but empty if cell C isn't an error?
My issue is that I want to have cell E11 equal to cell E8 if cell I8 is an error, but have cell E11 be empty if cell I8 ISN'T an error. I have tried using various combinations of IFERROR and IF funct...
In E11:
=IF(ISERROR(I8), E8, "")
This will cause a problem with F12, so change the formula there to
=IF(E11="", "", E11/(D12^2)*-1)
Also: I haven't found any way to do the opposite of IFERROR, eg. ifNOTerror. I would like to have a formula similar to the one @HansVogelaar mentioned in cell E15, but IFERROR should be reversed in some way. Is there any way to do this?
=IF(NOT(ISERROR(something)), value_if_no_error, value_if_error)