Boolean Algebra In Excel
In Boolean algebra, there are only two possible results for a math operation: 1 or 0, which, as we know, correspond to the logical values TRUE and FALSE. AND logic corresponds to multiplication. Anything multiplied by 0 is 0, and anything multiplied by 1 remains unchanged. If I multiply A times B, you can see how this works. To get a result of 1, both A and B must be 1....