Get startedGet started for free

Which conditional formula is right?

A colleague in the HR team at DataCo has sent you a table from one of their HR files, where a new column has been added using a conditional formula called Male > 30. However, they do not know what formula was used so that they can recreate it.

DataCo sample table from HR showing the employee first name, gender, age, and the column created using a conditional formula.

Which formula(s) could be used to create the Male > 30 column?

This exercise is part of the course

Data Preparation in Excel

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise