Explanation
Data validation rules are triggered when a user adds or changes a cell value.
The AND function takes multiple arguments (logical expressions) and returns TRUE only when all arguments return TRUE.
If the count is less than 2, the logical expression returns TRUE.
Be aware that numeric input includes dates and times, whole numbers, and decimal values.
AND returns TRUEonly if all the conditions are met.
If any conditions are not met, the AND function returns FALSE.
COUNTIF can be used to count…
