Hi

One way
=IF(AND(D10=1,OR(D2=1,D3=2)),1,0)
or, without IF()
=MIN(1,AND(D2=1,D10=1)+AND(D3=2,D10=1))

Regards

Roger Govier


T.R. Young wrote:
I am trying to make the following statement happen in a cell, but can't seem
to get the logic correct. I am not even sure that it can happen, but here is
basically what I want;

IF D2=1 AND D10=1 OR IF D3=2 AND D10=1 THEN 1 ELSE 0

If this can actually be done, what would the formula be?