Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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