data validation: formula for validating only multiples of 10

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

need formula for validating data in a cell. function required is for allowing
only multiples of 10
 
You can use the custom option on data validation, with a formula like:
=(MOD(A1,10)=0)

Hope this helps,
Miguel.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula and Data Validation parallely 1
custom data validation on cells with data validation values 2
data validation across multiple columns 1
Data Validation 1
Multiple data validation criteria? 1
Windows 10 How to improve network speed in Windows 10 by increasing IRPStackSize 5
Data validation for specific text, for example "blue"? 1
Data Validation - Complex Q 2

Back
Top