On Mon, 4 Feb 2008 19:09:00 -0800, doyree
wrote:

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

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