|
Featured Tutorial
Featured Macro
Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format
For Data Analysis learn about AND & OR criteria and Boolean and see how to:
1) Counting with 3 AND criteria and the 3rd AND criteria contains an OR criteria
2) Adding with 3 AND criteria and the 3rd AND criteria contains an OR criteria
3) Conditional Formatting with 3 AND criteria and the 3rd AND criteria contains an OR criteria
Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm
1) Counting with 3 AND criteria and the 3rd AND criteria contains an OR criteria
2) Adding with 3 AND criteria and the 3rd AND criteria contains an OR criteria
3) Conditional Formatting with 3 AND criteria and the 3rd AND criteria contains an OR criteria
Download file: http://flightline.highline.edu/mgirvin/ExcelIsFun.htm