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