Main Profile

At A Glance

Excel Array Formula Series #7: Boolean Logic & Criteria

See how to create array formulas for Summing and Counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions. See how to create a dynamic table and Chart bases on a cell with Data Validation drop-down list. Learn the TRUE*TRUE = 1, TRUE*FALSE = 0, FALSE*TRUE= 0, FALSE*FALSE = 0. Learn that 1 = TRUE and 0 = FALSE. In this series see how to create array formulas in Excel. Array formulas can take complex series of formula calculations and reduce them down to a single formula that sits in just one cell! You will see how to create array formulas and see how to use Array Functions.
Length: 10:05

Contact

Questions about Excel Array Formula Series #7: Boolean Logic & Criteria

Want more info about Excel Array Formula Series #7: Boolean Logic & Criteria? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question