ExcelBanter - Check last digit in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Check last digit in cell (https://www.excelbanter.com/excel-programming/325364-check-last-digit-cell.html)

NacellesEng

Check last digit in cell

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!

Mike Macgowan

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!

All times are GMT +1. The time now is 04:55 AM.