# if function + or function

#### Elise Nerlove

##### Board Regular
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!

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
If(or(h7="peppers",h7="pesto"),if(g7<3,"ok","false")

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")))))))

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"))

Replies
1
Views
451
Replies
6
Views
259
Replies
3
Views
572
Replies
4
Views
128
Replies
1
Views
230

1,221,418
Messages
6,159,795
Members
451,589
Latest member
Harold14

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back