Formula Please

[Dazzawm]

I have column C. I would like a formula please to give me a result of - if the last digit is a number then yes, if the last digit is a letter then no. Thanks.

 

[Aladin Akyurek]

Try to give an example. Are you looking at a single cell or multiple cells in C at once?

 

[Finalfight40]

Something like this?

=IF(ISNUMBER(RIGHT(C1, 1)*1), "yes", "no")

 

[Special-K99]

Something like this?

=IF(ISNUMBER(RIGHT(C1, 1)*1), "yes", "no")

Why have you got "*1" in there?
You dont need it

 

[Dazzawm]

Something like this?

=IF(ISNUMBER(RIGHT(C1, 1)*1), "yes", "no")

Thanks thats seemed to have done it.

 

[Finalfight40]

Why have you got "*1" in there?
You dont need it

If i have got a cell with 21r4 for example, multiplying by 1 will convert it to a number otherwise it will return text if i'm not mistaken?

 

[Fluff]

RIGHT will always return text regardless of the cell value, but ISNUMBER will try to convert that to a number, so in this case you do not need the *1

 

[Finalfight40]

RIGHT will always return text regardless of the cell value, but ISNUMBER will try to convert that to a number, so in this case you do not need the *1

How comes when i remove it from the equation, it will return False because i did try this as well?

 

[Fluff]

You're quite right ISNUMBER does not convert a string to a number, I was getting confused with ISNUMERIC in VBA

 

[Aladin Akyurek]

RIGHT(C1,1)

and

RIGH(C1)

are qequivalent.

ISNUMBER(RIGHT(C1,1)*1)

iSNUMBER(RIGHT(C1)*1)

iSNUMBER(RIGHT(C1)+0)

are all equivalent where *1 or +0 are necessary.