View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RayC RayC is offline
external usenet poster
 
Posts: 4
Default Ensuring input is rounded up to nearest 10

I am creating a form for hiring cutlery for my local village hall (a
charity). I need to ensure that hirers only order cutlery in multiples of 10.
How can I validate their input so that if they enter eg 33 it is
automatically rounded up to 40?
Thanks

Ray