please help me out with a formula.

mhanna807 I'm going to let you figure out the exact formula yourself, but when you read the question carefully, all players >508 are pink. So you don't need to test for >508 AND gender.

The solution thus needs to test for:

if <=508 AND male, then purple, else if <= 508 AND female, then green, otherwise pink.

A working formula, (but not in line with the specific instructions as it doesn't include AND), would be:

=IF(D10>508,"pink",IF(C10="male","purple","green"))

assuming that the gender will always be male or female, i.e. no blanks.

This one first checks the hight. Everyone >508 gets pink. Then checks for either of the gender types (male or female) and sets the color for true and for false, as all of these players will be <=508. no need to check that again. So you could also check for female and swap the colors. Like this:

=IF(D10>508,"pink",IF(C10="female","green","purple))