IF, AND, THEN Help

Copper Contributor

Good Day

 

I am trying to create a formula with the following conditions:

 

If Male and > 180cm, "Tall", "Average". If Female and > 170cm,"Tall","Average".

 

The simplified spreadsheet is attached, with the formula required in column D.

 

Much appreciated and kind regards

 

Marlon

5 Replies

@Marlon_Hartnick 

Try this one:

=CHOOSE(IF(B3="Male",1,2),IF(C3>180,"Tall","Average"),IF(C3>170,"Tall","Average"))

@Marlon_Hartnick 

Try this:

=IF(((C3>180)*(B3="Male"))+((C3>170)*(B3="Female")),"Tall","Average")
Many thanks Patrick2788 - it works perfectly.

Much appreciated and kind regards.
Many thanks Delef Lewin - it does exactly what I need it to do.

Much appreciated and kind regards.
You're welcome!