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: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Logical compariso...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.