Combining together multiple IF statements

all the following conditition should be satisfied the eligilibity

age<=40 years
height>=170 cm
qualification = Graduate
nationality = british

if all the condition satisfy the output will be "Eligible". if any one of the above condition not satisfied, the output will be "Not Eligible".

please help me

You didn't say what cells are used for age, height etc., so you will need to adapt this to your cell references:

=IF(AND(age<=40,height>=170,quals="Graduate",nationality="British"),"Eligible","Not Eligible")

Hope this helps.

Pete

Thank you very much.
is there any technique to solve the problem only through IF function??

Originally Posted by jeffreybrown

Try...

Formula:

Please Login or Register  to view this content.

Originally Posted by jupitar

...is there any technique to solve the problem only through IF function??

Seems little point in doing that, but here's one way:

=IF(age<=40,IF(height>=170,IF(quals="Graduate",IF(nationality="British","Eligible","Not Eligible")","Not Eligible")","Not Eligible")","Not Eligible")

Hope this helps.

Pete

Hello jupitar, and welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself.
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.