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)
=IF(ISERROR(I8),E8,"")