I have tried various formulas and none are giving me the result I would like under column H. I separated and bolded the part of the formula that is not working.
=IF(AND(D2>25,G2="F"),"Women",IF(AND(D2>25,G2="M"),"Men",IF(AND(D2>=20,D2<=25),"Young Adult", IF(OR(F2="Yes",D2<=19),"Teen"))))
I want to get H to result as Teen if age is less than or equal to 19 OR if H.S. indicates yes. Row 6 shows it will work when I have an age less than 19 but I would like it to show teen if D is blank as well. Any recommendations? Thank you.
=IF(AND(D2>25,G2="F"),"Women",IF(AND(D2>25,G2="M"),"Men",IF(AND(D2>=20,D2<=25),"Young Adult", IF(OR(F2="Yes",D2<=19),"Teen"))))
I want to get H to result as Teen if age is less than or equal to 19 OR if H.S. indicates yes. Row 6 shows it will work when I have an age less than 19 but I would like it to show teen if D is blank as well. Any recommendations? Thank you.