Hi all,
I am performing a mathematical calculation on a number of cells, but I get an error when the calculation is performed on a non-numeric cell.
Is there a way of filtering the formula to exclude the non-numeric cells... something like: if(isnumeric(A1),....)?
I know that I can use if(iserror(.....)), however I was hoping to specifically prevent errors being caused from non-numeric values.
Thanks in advance to all viewers and repliers,
Heski
Bookmarks