Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple problem? | Excel Worksheet Functions | |||
Logical formula problem | Excel Worksheet Functions | |||
Problem with nested logical formula. | Excel Worksheet Functions | |||
Logical problem | Excel Discussion (Misc queries) |