ISNUMBER problem

  • Thread starter Thread starter Mark
  • Start date Start date
M

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 G3. 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?
 
Need to use the VALUE function to convert the right character to a number
(if it is, indeed, a number!)

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