Note: formulas are entered relative to the upper left cell in the range, which is B5 in this example. The “stop if true” option is enabled for the first two rules to prevent further processing, since the rules are mutually exclusive.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.