|
Featured Tutorial
Featured Macro
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)
SUMPRODUCT function (DON'T have to use Ctrl + Shift + Enter)
Array with SUM function (must use Ctrl + Shift + Enter)