Another Excel needed

[Novoiceleft]

Thanks for the help earlier. I managed to do it ... !!

Now I have another similar one

I have 4 columns A, B, C, D which can contain only "1" or "0"

I want a result in Column E as follows

Column E = "1" if either A or B = "1". But, that is overridden if either columns C or D = "1" - in which case Column E = "0".

Many thanks !!

NoVoice

[EssDeeAitch]

Thanks for the help earlier. I managed to do it ... !!

Now I have another similar one

I have 4 columns A, B, C, D which can contain only "1" or "0"

I want a result in Column E as follows

Column E = "1" if either A or B = "1". But, that is overridden if either columns C or D = "1" - in which case Column E = "0".

Many thanks !!

NoVoice

Try this

=IF(SUM(C3:D3)>=1,0,1)

[AleisterCrowley]

wouldn't work for all zeroes?

I don't like big nested statements
I tend to concatenate the columns and use a table with vlookup
Easier if you use y and n rather than 1 and 0
So you may get yyny, yyyn etc

[EssDeeAitch]

wouldn't work for all zeroes?

I don't like big nested statements
I tend to concatenate the columns and use a table with vlookup
Easier if you use y and n rather than 1 and 0
So you may get yyny, yyyn etc

No, it won't work if all values are zero and I should have stated that. I assumed (which may be wrong) that there would be a 1 value somewhere.

[Novoiceleft]

Thanks EssDeeAitch but I don't think that, on its own, takes account of the first condition.... I will try to add it to something that deals with the first bit.

Aleister - I agree - but this is actually a dry run for a Sharepoint formula I need and Sharepoint does not have VLOOKUP !

NoVoice

[scrumpyjack]

=IF(SUM(C1:D1)>0,0,IF(SUM(A1,B1)>0,1,0))

should do it

[Novoiceleft]

It does indeed...Thank you so much !!

NoVoice

[modellingman]

Without IF...

=(1-(1-A1)*(1-B1))*(1-C1)*(1-D1)