if function + or function

Elise Nerlove

Board Regular
Joined
Dec 17, 2009
Messages
94
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!
 

Some videos you may like

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Elise Nerlove

Board Regular
Joined
Dec 17, 2009
Messages
94
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

Active Member
Joined
Mar 14, 2002
Messages
469
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"))
 

Watch MrExcel Video

Forum statistics

Threads
1,109,054
Messages
5,526,507
Members
409,704
Latest member
saialkesh

This Week's Hot Topics

Top