ISNUMBER returning FALSE

From Rockcliffe Library Network
Revision as of 12:28, 30 December 2018 by Kevin Feenan (Talk | contribs) (Created page with "== 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 B...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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