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

Detlef_Lewin

Silver Contributor

Oct 27, 2022

Marlon_Hartnick

Try this:

=IF(((C3>180)*(B3="Male"))+((C3>170)*(B3="Female")),"Tall","Average")

Marlon_Hartnick

Copper Contributor

Oct 27, 2022

Many thanks Delef Lewin - it does exactly what I need it to do.

Much appreciated and kind regards.