Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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..." |
#2
|
|||
|
|||
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..." |
#3
|
|||
|
|||
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..." |
#4
|
|||
|
|||
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..." |
#5
|
|||
|
|||
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..." |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
Can this be done / how?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|