ISNUMBER problem (corrected message)

  • 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 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?
 
Hi
try
=IF(ISNUMBER(--RIGHT(A1,1)),"Y","N")

the '--' converts the text to a number (if it is a number)
 
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)
 
=IF(ISNUMBER(--RIGHT(A1,1)),"Y","N")

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

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

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


--ron
 
Back
Top