I am working on an Excel spreadsheet and I need to add some data validation so the user can not enter the wrong amount. I need to use conditional validation and not a list whereby the user selects from increments of 25, starting at 25. Any ideas?
I am working on an Excel spreadsheet and I need to add some data validation so the user can not enter the wrong amount. I need to use conditional validation and not a list whereby the user selects from increments of 25, starting at 25. Any ideas?
assuming you are adding data validation to cell A1
=MOD(A1,5)=0
Replace cell A1 with the cell you want the data validation in
thanks Paula
Congratulations @angelak! You have completed the following achievement on the Hive blockchain and have been rewarded with new badge(s) :
You can view your badges on your board And compare to others on the Ranking
If you no longer want to receive notifications, reply to this comment with the word
STOPTo support your work, I also upvoted your post!
Do not miss the last post from @hivebuzz:
Congratulations @angelak! You received a personal badge!
You can view your badges on your board And compare to others on the Ranking
Do not miss the last post from @hivebuzz: