Oct 27 2022 10:41 AM
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
Oct 27 2022 10:50 AM
Try this one:
=CHOOSE(IF(B3="Male",1,2),IF(C3>180,"Tall","Average"),IF(C3>170,"Tall","Average"))
Oct 27 2022 10:54 AM
Oct 27 2022 11:08 AM
Oct 27 2022 11:09 AM