Help:ISNUMBER returning FALSE
Problem
ISNUMBER is returning FALSE when provided with a formula that references a cell containing a number. For example,
In cell A1 I have a string "AA42"
In cell B1 I have the number '42' as the result of a formula =RIGHT(A1,2)
In cell C1 I have the formula =ISNUMBER(B1) however this formula is returning FALSE
Solution
ISNUMBER is expecting a value. As the original value was text, even though the cell format might be set to 'General', excel needs to be told explicitly that what it is trying to evaluate is a number.
To correct the formula use the following:
=ISNUMBER(VALUE(B1))
