I am looking for some help as have been hitting my head against a wall all morning!
I am trying to find a formula to pull out if someone is male or female or other. sex code (1 = Female, 2 = Male, 3 = Other) from BD11100005 this digit
If the bolded is (1 = Female, 2 = Male, 3 = Other).I know I need to use the IFs function,
=IFS(MRN=1,"F",2,"M",3,"O"), but do I need to include MID, left or right to specify the position of the bolded number?
Any help much appreciated I need this done by ending of tomorrow.
I am trying to find a formula to pull out if someone is male or female or other. sex code (1 = Female, 2 = Male, 3 = Other) from BD11100005 this digit
If the bolded is (1 = Female, 2 = Male, 3 = Other).I know I need to use the IFs function,
=IFS(MRN=1,"F",2,"M",3,"O"), but do I need to include MID, left or right to specify the position of the bolded number?
Any help much appreciated I need this done by ending of tomorrow.