Something like this:

=IF(AND(K9=1,K20=1),1,0)

or even:

=K9*K20

if both cells can only be 1 or 0.

Hope this helps.

Pete

On Feb 4, 5:19*pm, kknob wrote:
Hi I am having a logical problem with If statement....

this is my formula:

=IF(K9=$K$20&$K$20=1, 1, 0)

is there another way of doing this or what is the problem, right now,
the formula always gives 0, even when K9 and K20 = 1..... *I don't
know if there is something simple that I am overlooking??

what i want to do is output a 1 when K9 and K20 both equal 1, but not
when they both equal 0.

thanks!!