For example, if a user inputs 15%: If a user enters 15.5%, the formula evaluates like this This formula doesn’t validate anything else, for example that percentages are less than 100%. Additional conditions can be added with the AND function. Notes: Data validation rules are triggered when a user adds or changes a cell value. Cell references in data validation formulas are relative to the upper left cell in the range selected when the validation rule is defined, in this case B5.

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.