Data Validation Formula Generator
Data validation formulas control what users can enter in cells. Create dependent dropdowns, enforce numeric ranges, require dates within periods, and more.
Syntax
Custom formula in data validation (must return TRUE to allow input)Try it — generate a Data Validation Formulas formula
Examples
Dependent dropdown list
=INDIRECT(A2)Creates a dropdown that changes based on the selection in A2. Each option in A2 should be a named range.
Only allow business emails
=NOT(ISNUMBER(SEARCH("gmail.com", A1)))Rejects entries containing "gmail.com" — only allows business email domains.
Tips
- ✓Data validation formulas must return TRUE to allow input, FALSE to reject.
- ✓Use INDIRECT for dependent dropdown lists that change based on another cell.
- ✓Add an input message and error message to guide users when validation fails.
Related Formulas
Conditional Formatting Formulas
Custom conditional formatting formulas let you highlight cells based on complex ...
Nested IF
Nested IF formulas let you test multiple conditions and return different values ...
FILTER
FILTER returns rows from a range that meet specified conditions. It's like AutoF...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free