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!
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!