get last digit =MID(A1, LAST NUMBER, 1)
if statement =IF(MOD(A1,2)=0,"FEMALE","MALE")
This post has been edited by GPKGB: Dec 27 2018, 11:39 AM
Need help with Excel functions, To find Gender using IC number Q&A
|
|
 Dec 27 2018, 11:38 AM
Return to original view | Post
#1
|
 
Newbie
14 posts Joined: Aug 2010 
|
|
Quote| Bump Topic Add ReplyOptions New Topic |
| Change to: |  0.0150sec
 0.56
 7 queries
 GZIP Disabled
Time is now: 18th December 2025 - 11:17 AM |
All Rights Reserved © 2002- 2025 Vijandren Ramadass (~unite against racism~)
Powered by Invision Power Board © 2025 IPS, Inc.