Combining If with multiple And/Or

[K0D54]

Hello. I wanted to know if it's possible to combine an if statement with multiple and functions as well as or. I am trying to do something like this:

If (UCase(Cells(i, "G").Value) <> "" And (UCase(Cells(i, "D").Value) = "PIZZA") Or (UCase(Cells(i, "G").Value) <> "" And (UCase(Cells(i, "D").Value) = "HAMBURGERS") Then

However, I am getting a compile error saying it is expected a ). I am unsure if what I am trying to do is possible or if I am just entering the information incorrectly. Any help would be much appreciated. Thank you.

 

[Joe4]

It sure is possible.
You have an error because you have 12 left parends "(" and 10 right ones ")".
The numbers must match exactly to have a valid formula.

Where you put them will also affect the groupings and how they work, i.e.
(A and B) or C
is not the same as:
A and (B or C)

 

[K0D54]

Thank you!

 

[Joe4]

You are welcome.