Excel Logical Tests - Seminar
Logical Test in Excel
Description
Logical tests – functions that test if a comparison is true or false – serve dozens of roles across a workbook. In this session, we’ll demonstrate how to categorize data, color-code lists, and control data entry with these logical expressions.
Topics include:
Using Boolean expressions in a workbook
Color-coding with Boolean tests
Creating custom data validation tests
Categorizing data with IF, AND, and OR functions