Hello Everyone,
I created this sheet for the organization which I volunteer unfortunately I am
stuck! For those less fortunate families so we can provide them with gifts.
I would like it to detect automatically gender whether it be male of female.
Here are the codes I have so far:
MALE =IF(C121<6,"",IF(C121>=11,"",IF(C121>=6,"M",)))
FEMALE =IF($C124<=5,"F","")
Thank you in advance.
I created this sheet for the organization which I volunteer unfortunately I am
stuck! For those less fortunate families so we can provide them with gifts.
I would like it to detect automatically gender whether it be male of female.
Here are the codes I have so far:
MALE =IF(C121<6,"",IF(C121>=11,"",IF(C121>=6,"M",)))
FEMALE =IF($C124<=5,"F","")
Thank you in advance.