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))

Retrieved from "https://urockcliffe.mywikis.wiki/w139/index.php?title=Help:ISNUMBER_returning_FALSE&oldid=95"
Cookies help us deliver our services. By using our services, you agree to our use of cookies.
More information