Forum Discussion
IF, AND, THEN Help
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 attac...
Try this one:
=CHOOSE(IF(B3="Male",1,2),IF(C3>180,"Tall","Average"),IF(C3>170,"Tall","Average"))
Many thanks Patrick2788 - it works perfectly.
Much appreciated and kind regards.
Much appreciated and kind regards.
- You're welcome!