Check that a value is a number

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

Hi,

You are right ...

Please Login or Register  to view this content.

HTH
Carim

Thanks Carim