Salutation. I've exhausted other forms of help, so I'm taking a shot on this forum.
I am attempting to use two conditional expressions within a logical expression (IF statement) in MS Excel 2007. Each of the conditional expressions test individually as TRUE, but when separated with an &, they evaluate as false. I tried using AND to separate them, and that expression is deemed #INVALID. I've tried using adjacent cells on the same sheet, but the result is the same even when specifying a cell on an alternate sheet (named Pos2). Here is the logical expression that is evaluating incorrectly:
=IF(B7=1 & Pos2!N7=1,1,0)
Again, the individual expressions ( B7=1 as well as Pos2!N7=1 ) evaluate to 1 when by themselves. Together in the above statement they evaluate to 0, when they should evaluate to 1.
Any help or input on this would be hugely appreciated.
Regards,
~Skywise
Aka Mark
Bookmarks