Thread: ID number to Gender
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mags Mags is offline
external usenet poster
  
Posts: 11
Default ID number to Gender
I want to see if the employee is a male or female from the ID number?

ID number - 751105 0 931087

The SEVENTH number will tell you if the employee is a male or female
0-4 = Female
5-9 = Male

What formule can I use?
Reply With QuoteReply With Quote