Multiple arguments in one formula

[jodilee3]

Hi Everyone,

I have spent way to much time trying to connect everything into one formula, to the point where i am not sure if it can be done. Hopefully my explanation below is not too confusing. I need to make the following work:

If cell C2 contains Apple,Orange or pear and cell D2 is less than 0.2 then pass or more than 0.2 fail. If cell C2 contains grapes, banana, mango and d2 is less than 1.2 pass or more than 1.2 fail.

I need this all in one formula to make this work, can anyone help?

 

[Jonmo1]

Welcome to the board.

Why does it have to be all in one formula ?
It's OK to use more than one cell to solve a problem, that's the whole point of Excel giving you over 16000 columns and 2Million rows worth of cells. Use some of them.

Anyway, for that specific scenario, try

=IF(OR(C2={"Apple","Orange","Pair"}),IF(D2<0.2,"Pass","Fail"),IF(OR(C2={"Grapes","Banana","Mango"}),IF(D2<1.2,"Pass","Fail"))

 

[Jonmo1]

An easier way would be to setup a lookup table for the number value of each fruit...
Say F2:G7

F2:F7 = Apple Orange Pair Grapes Banana Mango
G2:G7 = 0.2 0.2 0.2 1.2 1.2 1.2

Then you do
=IF(D2<VLOOKUP(C2,$F$2:$G$7,2,0),"Pass","Fail")