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?
 
Top