Does anybody know how I write a formula to check whether a cell is an error (#VALUE!,#DIV/0!, etc., etc.,). The formula should ignore the cell if it is an error and return the value in the cell if it is not an error? I was thinking it would be something like below, but this just returns zero for me. =IF(ISERROR(I4),0,I4) where I4 is the cell I am checking and it does not contain an error. Thanks.
is I4 = 0? this formula works for me.
No, there was a formula in I4 but I’ve got it now anyway. Thanks.
try “isnumber”