Dear All,
I want to combine the below formula in one formula, how do I do that?
IF(A1="Male", IF(B1>18, "Man", "Boy"), "Boy")
and
IF(A2="Female", IF(B2>18, "Woman", "Girl"), "Girl")
Thanks in advance :-)
Dear All,
I want to combine the below formula in one formula, how do I do that?
IF(A1="Male", IF(B1>18, "Man", "Boy"), "Boy")
and
IF(A2="Female", IF(B2>18, "Woman", "Girl"), "Girl")
Thanks in advance :-)
Try this:
=IF(A1="Male",IF(B1>18,"Man","Boy"),IF(A2="Female",IF(B2>18,"Woman","Girl"),"Other"))
(from mobile so not yet tested)