Can this be done / how?
 

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..."

Can this be done / how?
 

Try this:
=IF(OR(AND(D3=2,D20=1),AND(D2=1,D10=1)),1,0)
************
Anne Troy
www.OfficeArticles.com

"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..."

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..."

Can this be done / how?
 

Hi!

Try this:

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

Biff

"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..."

Can this be done / how?
 

Thanks, everyone! That solved my problem! Greatly appreciated.
--
"...I'm just a simple man, trying to make my way in the universe..."


"Bob Phillips" wrote:

=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..."

Can this be done / how?
 

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?

Can this be done / how?
 

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)