Data Validation on Cells

R

ringo tan

How can I restraint the user from entering odd numbers in the cell? But I need the outcome to be in multiples of 5?
Thanks.


Ringo Tan
 
J

JE McGimpsey

So you want to restrict entries to even multiples of 5?

Assuming your input cell is A1:

Allow: Custom
Formula: =MOD(A1,10)=0
 
J

JulieD

or do you, once the person has entered the (even) number round the number to
the nearest multiple of 5?

if so, you can't do this in the same cell without using some VBA code.

please clarify if this is what you want

Regards
JulieD

ringo tan said:
How can I restraint the user from entering odd numbers in the cell? But I
Click to expand...
need the outcome to be in multiples of 5?
 

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

Data Validation on Cells 1
Data Validation on Numbers 1
Formula Error 3
Cell Validation for Decimals 2
Excel does not accept text format! 0
Crating User Form to Add Names 1
Cell Validation 2
trim spaces in a cell 4

Top