11/8/2023 0 Comments Minimal data duplicacy definitionWhen setting up a formula-based Excel validation rule, please keep in mind that all cell references in your formula are relative to the upper left cell in the selected range. In many situations, if you select the Ignore blank box when defining the rule (usually selected by default) and one or more cells referenced in your formula is blank, any value will be allowed in the validated cell.Ībsolute and relative cell references in data validation formulas If you use a formula-based criteria in a built-in rule (like we did to validate times based on the current time), it can also return another numeric value.Įxcel data validation formula should not refer to an empty cell If you are creating a custom rule, the formula should return the logical values of TRUE and FALSE or the values of 1 and 0 equating to them, respectively. Validation formula does not refer to an empty cellĬheck the correctness of your Excel data validation formulaįor starters, copy your validation formula into some cell to make sure it does not return an error such as #N/A, #VALUE or #DIV/0!.If your formula-based data validation rule does not work as expected, there are 3 main points to check: The screenshot below shows a rule that allows only times greater than the current time:Ĭustom Excel data validation rule not working To validate times based on the current time:.To validate dates and times based on the current date and time:. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |