ISNUMBER QUESTION

D

doyree

hello,
i'm not sure why i'm not getting "false" from below formula.
could someone tell me why and how i can get "true"?
thanks much!!~!!


A
ABC1234

=ISNUMBER(RIGHT(A2,1))
 
R

Ron Rosenfeld

hello,
i'm not sure why i'm not getting "false" from below formula.
could someone tell me why and how i can get "true"?
thanks much!!~!!


A
ABC1234

=ISNUMBER(RIGHT(A2,1))
Click to expand...

With

A2: ABC1234

I get FALSE from your formula.

The "4" is text, not a number.

If you want to get it to be true, then you must convert it from the text
representation of a number to a true number. There are various ways of doing
that.

=ISNUMBER(-RIGHT(A2,1))

is one of them.


--ron
 
J

Jim Cone

=ISNUMBER(RIGHT(A2,1)) returns a number enclosed in quotation marks... "4"
=ISNUMBER(RIGHT(A2,1)*1) returns a number... 4
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"doyree" <
wrote in message
hello,
i'm not sure why i'm not getting "false" from below formula.
could someone tell me why and how i can get "true"?
thanks much!!~!!

A
ABC1234

=ISNUMBER(RIGHT(A2,1))
 
T

Tyro

The cell A2 contains the TEXT "ABC1234" The rightmost character,
RIGHT(A2,1) is a "4" which is TEXT not a number.
If you want to test that to see if it is something that can be converted to
a number, you can also use =ISNUMBER(VALUE(RIGHT(A2,1)))

Tyro
 
F

FSt1

hi
what you see on the screen may not always be what you think you're seeing.
you are seeing a 4 but xl sees it as text.
any cell with letters and number in it is automaticly classed by xl as text.
take the formula =right(A2,1) and paste it as values. text
also this formula =type(right(A2,1)) retuns 2 which is text.
so you are getting false because it's not "defined as number" by xl.
if you want it to be true then
=ISNUMBER(VALUE(RIGHT(A2,1)))
the value function converts it to a number.

by the way....uh....what are you trying to do?

Regards
FSt1
 
D

Dave Peterson

Unless A1 looks something like: ABC12340

(Sometimes being different just doesn't work out <bg>.)
 
Top