Shelly wrote...
I've been playing with nested IFs, ORs, and Ands, with no luck. There may be
an easier way to do what I want, but I'm trying to accomplish the following:

If (B42 = x and B8 = y) or if (B43 = x and B9 = y) or if (B44 = x and B10 = y)
Then insert Yes into cell B1
....

An alternative,

=IF(SUMPRODUCT((B42:B44=x)*(B8:B10=y)),"Yes","")