I'm using Excel custom data validation to restrict entry in A2, if A1 is 0 or blank. The formula =A1>0 works just fine if A1 is a number greater than 0, but if A1 is blank, the restriction does not work. Put another way, I want a blank cell In A1 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 solve the issue. Is there a formula for this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Data Validation Restriction.
- Thread starter Yago87
- Start date
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 73,974
- Office Version
- 365
- Platform
- Windows
Duplicate: https://www.mrexcel.com/forum/excel-questions/1037356-custom-data-validation-formula.html
You have re-posted this question 3 times now. Please STOP and post all follow-ups back to the original thread indicated above. You actually got a reply there that you never replied to!
Please read and heed all rules, especially rule 12 here:Forum Rules
Repeated failure to comply may result in loss of posting privileges.
You have re-posted this question 3 times now. Please STOP and post all follow-ups back to the original thread indicated above. You actually got a reply there that you never replied to!
Please read and heed all rules, especially rule 12 here:Forum Rules
Repeated failure to comply may result in loss of posting privileges.
Last edited:
Upvote
0
- Status
