Basic 'IF' Statment Calc problems

[AllenMead]

Ok, I need to know how to calculate the following in 1 cell, cell C


First Equation [I had this:=IF(OR(AND(A1=1,B1=1),OR(A1=1,B1=0)),1,0) but it doesn't work]

Column A = 1
Column B = 1

Column C = 1

Column A = 1
Column B = 0

Column C = 1

Column A = 0
Column B = 1

Column C = 0

Second Equation

Column A = 1
Column B = 1

Column C = 0

Column A = 1
Column B = 0

Column C = 0

Column A = 0
Column B = 1

Column C = 1


any help would be much appreciated! Cannot see the wood for the trees at the moment!!!!

[NBVC]

Maybe:

=IF(A1=1,1,0)

and for 2nd formula

=IF(AND(A1=0,B1=1),1,0)

[AllenMead]

Kind of, hopefully this may explain it better;

IF
((A1=1, B1=1), then 1 or (A1=1, B1=0), then 1 or (A1=0, B1=1), then 0) As 1 Formula


IF
((A1=1, B1=1), then 0 or (A1=1, B1=0), then 0 or (A1=0, B1=1), then 1) As 1 Formula

[NBVC]

What's the difference in the results between that and what I gave you?

[romperstomper]

Assuming B1 actually matters:
=--AND(A1=1,OR(B1={0,1}))
and:
=--NOT(AND(A1=1,OR(B1={0,1})))

[AllenMead]

What's the difference in the results between that and what I gave you?

It's been one of those days! Trying to make it more complicated than it needs to be.

In answer, yep, looks like what you have said is spot on. Thank you!

[Cutter]

You haven't said what you want for A=0 B=0

So from what you did give for your first equation: C=A1 each time
And for your second equation: IF(B1>A1,1,0)

[AllenMead]

Opps, A=0 B=0 then C=0

[AllenMead]

@romperstomper spot on except (my fault) if A and B=0 then C=0 and not 1

[Cutter]

Then what I gave you still holds true.

[AllenMead]

@ Cutter, yes chap and thank you for your help