Hi Ray,

Bit of a compromise on what you are asking for, but you could
set Data Validation to custom with a formula like this,
=OR(A1=10,A1=20,A1=30,A1=40,A1=50)
and then set the error alert message to say
"Input must be in multiples of 10"

HTH
Martin



"RayC" wrote in message
...
Thanks, but how do I apply it to the same cell to avoid a circular
reference?
If the user tried to enter 33 I want that cell to show the 40.

--
Ray


"David Biddulph" wrote:

=CEILING(A1,10)
--
David Biddulph

"RayC" wrote in message
...
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