On 18/10/05 4:49 AM, in article
, "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?

Try =IF(AND(D10=1)*OR(D3=2,D2=1),1,0)