IF statement AND OR ?

[BJW75]

Hello,

This seems like a softball but I cannot seem to get this formula to work using various forms with both, one or either AND OR combined IF statements. THe latest attempt is below:
=IF(AND(A23="prod 1",OR(A23="prod 2"),B23="waste"),J23," ")

A23 is a column of multiple product choices. In larger reporting (like quarter and year end reports), we combine all into 2 subgroups so several will fall into a larger category.
B23 is the location or what was found so this remains as one option
J23 is the value if true
blank if false

All iterations that I have tried return TRUE or blank. Any guidance is appreciated.

 

[fhqwgads]

i dont think your OR is doing anything there. OR(A23="prod 2") and just having A23="prod 2" should give the same result since there's just the one logical statement to check

if you're trying to say "if A23 is prod 1 or prod 2, and B23 is waste, then J23" i think it should look like
=IF(AND(OR(A23="prod 1", A23="prod 2"), B23="waste"),J23," ")

 

[BJW75]

That fixed it. I am still new to large logical statements, preferring statistical formulas and simple.
Thank you!