Forum Discussion
Formula to lookup the last digit and second to last digit in VIN number
I have a fleet of 600 pieces of equipment. I need to perform a look up that looks at the last digit in the VIN and then another lookup for the 2nd to last digit. For example: VIN # 123456789 - I nee...
Let's say you have a VIN in D2.
Enter the following formula in E2:
=ISEVEN(E2)
This will return TRUE if the last digit is even, FALSE if it is odd.
Enter the following formula in F2:
=ISEVEN(QUOTIENT(D3,10))
This will return TRUE if the next-to-last digit is even, FALSE if it is odd.