Data Validation on Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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