IF...with multiple sets of combinations of criteria

[WildWill]

I have three columns of data, A, B, and C from which I want to draw the following results for each cell in column D:

If A>30 and B>5 and C>5 then D="Apples"
if A>30 and B<5 and C>5 then D="Pears"
if A>30 and B>5 and C<5 then D="Mangoes"
if A<30 then D="Guavas"

Please assist!

 

[pagrender]

Try this:
=IF(A1<30,"Guavas",IF(AND(B1>5,C1>5),"Apples",IF(AND(B1<5,C1>5),"Pears","Mangoes")))

 

[WildWill]

Thanks Pagrender - sorted!