How to Limit Cell Values to Multiple of 10?

  • Thread starter Thread starter ankoor.naik
  • Start date Start date
A

ankoor.naik

I'm creating an excel survey, and for each cell in the survey, I want
to ensure that users can only enter a value that is a multiple of 10
(E.g. 10, 20, 50).

Other than creating a drop down with all the multiples of 10, is there
any other way to do this?

Thanks!
 
Under Data/Validation/Custom

=MOD(B1/10,1)=0

Add input and output comments as desired...

Beege
 
Use Data Validation with a type of Custom and a formula of =MOD(F1,10)=0

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Lets say the replies are to be put into H4: H100
Select the range H4:H100; use the menu command Data | Validation
Specify Custom in the Allow box
In the Formula box enter =MOD(H4,10)=0 (do remember the opening = sign)
Of course, if your range is something else, the cell reference is the first
cell in your range.
You can also add a message that pops up if user makes an error
best wishes
 
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

Histogram/Frecuency for Multiple Response Questions 1
Scrabble Value calculation for Welsh words 0
Access Newbie trying to create Access Database for survey data 0
Count Cells Within 10 of a Cell Value 2
Lining up rows based on values 1
COUNTIF or SUMPRODUCT with multiple criteria 1
COUNTIF function query 6
totaling data from a drop down list 2

Back
Top