Help:ISNUMBER returning FALSE


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


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:


Cookies help us deliver our services. By using our services, you agree to our use of cookies.