IF, AND formula

0

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 :-)

Answer
Discuss

Answers

0
Selected Answer

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)

Discuss

Discussion

Thanks don I thinke this was I looking for ;-)   =IF(A1="Male",IF(B1>18,"Man","Boy"),IF(A1="Female",IF(B1>18,"Woman","Girl"),"Other"))   Thanks again
JMS (rep: 2) Jan 28, '17 at 4:11 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login