Excel Forum

Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas

See how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. See how to create Array Formulas in three different ways:
SUMPRODUCT function (DON'T have to use Ctrl + Shift + Enter)
Array with SUM function (must use Ctrl + Shift + Enter)

Got a Question? Ask it Here in the Forum.