View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Steve Hayes Steve Hayes is offline
external usenet poster
 
Posts: 18
Default ID number to Gender

On Wed, 21 May 2014 23:42:20 -0700 (PDT), wrote:

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?


Do you want gender or sex?

Male and Female are sexes, not genders.

Genders are masculine, feminine, neuter and trans, and perhaps a few orther
things as well.




--
Steve Hayes from Tshwane, South Africa
Web:
http://www.khanya.org.za/stevesig.htm
Blog: http://khanya.wordpress.com
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk