IF STATEMENT NOT EQUAL TO NUMBER

[wbloch]

HI,

I have a column filled with salesperson codes eg 63A, 63B, 63C etc...
But I also have in that column without an A or a B etc at the end.

I have written the following if statement: =if(right(d1) <> "A", if(right(d1)<>"B" etc......)

Surely there is a way to work out if the right character is a letter or a number and then I would have if the right of d1 is character then do whatever if it is a number do whatever?

Any suggestions?

Thanks!

 

[PaddyD]

check the help file for isnumber() & istext()

 

[LTunnicliffe]

Try this:

=IF(ISNUMBER(VALUE(RIGHT(B1,1))),"Whatever","Else Whatever")

Hope this helps!

 

[PaddyD]

Loren,

Coercions are somewhat more efficient than functon calls:
i
=ISNUMBER(--RIGHT(B2))

...marginally useful, but thought I'd point it out...