Forum Discussion

Copper Contributor

Oct 27, 2022

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...

Gender and Height Worksheet.xlsx12 KB

excel

Formulas and Functions

Marlon_Hartnick

Copper Contributor

Oct 27, 2022

Many thanks Patrick2788 - it works perfectly.

Much appreciated and kind regards.

Patrick2788

Silver Contributor

Oct 27, 2022

You're welcome!