View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kknob kknob is offline
external usenet poster
 
Posts: 6
Default 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!!