Excel Forum



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.





Got a Question? Ask it Here in the Forum.