View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Macgowan Mike Macgowan is offline
external usenet poster
 
Posts: 10
Default Check last digit in cell

=if(right(cell,1)=0,true condition,false condition)
"NacellesEng" wrote in message
oups.com...
I have a column of cells like the following:
LC0000030201000
LC0000030201001

I want to check the list digit in the cell and see if its a 0 or a 1 so
I can run different IF statements. Any ideas? Thanks!