Data Validation on Numbers

[ringo tan]

How do I restraint the user from entering odd numbers in the cell, that means
only allow even numbers but these even numbers must be in multiples of 5?

Example : 10,20,30,40................

Thank you.



Regards,
Ringo Tan

 

[Leo Heuser]

Ringo Tan

One way:

Choose "Custom" (or similar) in the validation box
and enter this formula

=(A1>0)*(MOD(A1,10)=0)

if negative numbers are also allowed, use

=(A1<>0)*(MOD(A1,10)=0)

if both negative numbers and zero are allowed:

=MOD(A1,10)=0