if function + or function

[Elise Nerlove]

Hi, i have this vlookup...but i want to say if H7 is equal to Peppers OR Pesto...how would you edit that in using an or function?

IF(H7="PEPPERS",IF(G7<3,"OK","FALSE")

thanks!

 

[ammdumas]

If(or(h7="peppers",h7="pesto"),if(g7<3,"ok","false")

 

[Elise Nerlove]

oK, so i gave you a shortened version of what i was actually trying to do....heres the full eqn, and excel is saying "youve entered too many arguments for this function"...****. I need all of these avaliable...is there anyway to make this function work??

=IF(H8="","",IF(OR(H8="PEPPERS",H8="GOURMET DELI"),IF(G8<3,"OK","FALSE")),IF(OR(H8="OLIVES", H8="PASTA SAUCE"),IF(G8<7.01,"OK","FALSE")),IF((OR(H8="ROASTED PEPPERS",H8="PESTO"),IF(G8<5.01,"OK","FALSE")))))))

 

[ammdumas]

I think this will cover you (double check all the brackets).

=IF(H8="","",IF(OR(AND(OR(H8="PEPPERS",H8="GOURMET DELI"),G8<3), AND(OR(H8="OLIVES", H8="PASTA SAUCE"),G8<7.01),AND(OR(H8="ROASTED PEPPERS",H8="PESTO"),G8<5.01))),"OK","FALSE"))