Excel Forum
Similar Content
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: Logical comparison operators allow you to compare values in Excel to see if they are equal...



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.