Confusing use of validation

[oddjob78]

Hi everyone,
basically what i need to able to do is set a validation rule that allows me to enter a value that is between 5 and 10 kgs but (and here comes the confusin bit is also rounded to the nearest 5kg. I tired using the[ like "?.?0" or "?.?5" ] command but have so far been unsucessful. Also i really like oranges.

 

[oddjob78]

Cheers !!!!

 

[kicken18]

I like oranges...also satsumers

 

[kicken18]

Pat, what kind of code would we be looking at here. I understand where to enter it and everything, but not what i would be entering as the code for it to round