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”