Boolean comparison: range vs. single cell
msimms wrote...
....
but how does a TRUE or FALSE result get translated into a NUMERIC VALUE?
....
Boolean (TRUE/FALSE) values used as operands to arithmetic operators
are automatically converted into 1s for TRUE and 0s for FALSE.
|