View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default Can this be done / how?

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"T.R. Young" wrote in message
...
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?
--
"...I'm just a simple man, trying to make my way in the universe..."