View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
[email protected] wwdeep@gmail.com is offline
external usenet poster
 
Posts: 1
Default ID number to Gender

On Thursday, 20 May 2010 16:14:01 UTC+8, Mags wrote:
I want to see if the employee is a male or female from the ID number?

ID number - 75110501310 8

The TWELVETH number will tell you if the employee is a male or female
EVEN NUMBER = Female
ODD NUMBER = Male

What formule can I use?