How to Limit Cell Values to Multiple of 10?

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!
 
B

Beege

Under Data/Validation/Custom

=MOD(B1/10,1)=0

Add input and output comments as desired...

Beege
 
B

Bob Phillips

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)
 
B

Bernard Liengme

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
 
Top