ISNUMBER problem (corrected message)

[Mark]

I am trying to identify if the right character of a cell is numeric
and populate another cell based on the value

e.g. cell A1 contains the text G3

To me, it appears that the right character is 3. Therefore, if I set
up the following function in cell B1, I would expect a Y in the B1
cell :

=IF(ISNUMBER(RIGHT(A1,1)),"Y","N")

This is not the case. The IF statement is returning a FALSE value, and
thus, my B1 cell contains N.

As far as I can tell, the RIGHT function is returning the number 3 in
double quotes, and I think that these quotes are causing the problem
(although I may be wrong). How can I get this to work?

 

[Frank Kabel]

Hi
try
=IF(ISNUMBER(--RIGHT(A1,1)),"Y","N")

the '--' converts the text to a number (if it is a number)

 

[Bob Phillips]

Mark,

Try this version

=IF(ISNUMBER(VALUE(RIGHT(A1,1))),"Y","N")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Ron Rosenfeld]

=IF(ISNUMBER(--RIGHT(A1,1)),"Y","N")

the '--' converts the text to a number (if it is a number)

Actually, for this purpose only a single unary is needed.

=IF(ISNUMBER(-RIGHT(A1,1)),"Y","N")


--ron