Simple Logical problem
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!!
|