I am trying to understand an apparent inconsistency in the way that Excel (2010 but potentially other versions) evaluates boolean expressions.
Start with a blank worksheet, and enter in A1 (say):
This gives TRUE which seems odd.
Next, if I evaluate B1 and NOT(C1) separately, I get 0 (Zero) and TRUE respectively.
If I then substitute those into the original formula I get:
which evaluates to FALSE.
Similarly, if I enter:
and put B2 = B1 (which is empty)
and C2 = NOT(C1) (which is also empty)
it evaluates to FALSE which is consistent with the evaluation by parts above, but inconsistent with the original construct.
Please can some explain what I am missing here?
PS: I can get around this by using =AND(B1=TRUE,NOT(C1)) or something similar, but that's not what I am asking.