custom data validation formula

[Yago87]

I'm using Excel custom data validation to restrict entry in D2, if D1 is 0 or blank. The formula =D1>0 works just fine if D1 is a number greater than 0, but if DI is blank, the restriction does not work. Put another way, I want a blank cell In D1 to be treated as if it was a zero. I've tried removing the checkmark in the box beside Ignore Blank in the validation criteria window but that does not help. . Help for this formula please?

 

[jtakw]

Original post here: https://www.mrexcel.com/forum/excel-questions/1037356-custom-data-validation-formula.html

Posted again here: https://www.mrexcel.com/forum/excel-questions/1037372-date-validation-formula.html

 

[Joe4]

Please do not post the same question multiple times. All clarifications, directly-related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).