Check that a value is a number
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,
You are right ...
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1