Excel Magic Trick #63: Boolean Logic & Array Formulas

Description

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