Data Validation - allow multiples of ...

[colmcg]

Can anyone tell me how I can apply Data Validation to a cell to allow only a number EXACTLY divisable by 5 to be entered.

Thanks in advance.

 

[ACommandLineKindaGuy]

If you're validating cell A1,

=Mod(A1,5)=0

Or maybe,

=Int(A1/5)*5=A1

 

[colmcg]

Thanks, both of your suggestions work equally well. Now I'm spoilt for choice.