Happy Holidays male or female

[sanch0156]

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.

 

[SSPoulin23]

im assuming you mean automatically, based on their input into a cell. but what would you like it to do once it detects the gender?

 

[sanch0156]

To place an M or an F in a given column.

I can send a Jpeg, but I'm not sure if this form allows it

Thank you for the quote response

 

[SSPoulin23]

=IF(C121="Male","M",IF(C121="Female","F","?"))

if they're typing their own option into C121, you may end up with choices other than male or female due to spelling errors or what have you. I would probably add a data validation to it, using a list hidden either on a different tab or somewhere on the sheet of Male or Female so they have to choose one or the other.

The "?" will fill in if they type some thing other than male or female. if you want it blank, just leave it as ""

hope that accomplishes what you're looking for!

 

[mikerickson]

Another option might be =UPPER(LEFT(C121, 1))

 

[sanch0156]

I apologize for not making this clear. I need it to work with the formula below. There are four columns age groups: 0 through 5, 6 through 10, 11 through 15 and 16 through 17. I need it to recognize example: row B2 Column B4 "M" for Male or F for Female in the corresponding cell.

=IF(B2<6,"",IF(B2>=11,"",IF(B2>=6,"M",)))

Child's Name	Age	Gender	0-5	6-10	11 -15	16 - 17
John
Jane

<tbody>
</tbody>

 

[mikerickson]

How would it know that "John" is male?

What gender is "Francis" or "Robin"?

 

[Macropod]

Presumably Age & Gender are specified in columns B & C, respectively. In that case, for columns D:G you could use a formula like:
=IF(MAX(INT(($B2-1)/5),0)-(COLUMN()-4)=0,$C2,"")

 

[sanch0156]

Child's Name	Age	Gender	0-5	6-10	11 -15
John	12	Male			M
Jane	5	Female	5

<tbody>
</tbody>

Thank you for responding appropriately "Macropod" really stressed trying to do this for approximately 65 unfortunate children.

To your question B&C are separate.

I was using this formula. Which only detects age. Let's use John for example I would put the formula below in F2 and as you can tell by the formula it would put an M at the end after it met all the criteria.

John =IF(B2<11,"",IF(B2>=16,"",IF(B2<=16,"M",))) This formula was placed in F2.

I would like to add a TEXT "F' or "M" in a cell for both age and gender.

 

[sanch0156]

I apologize meant to put an "F" in D2