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!
|