Ensuring input is rounded up to nearest 10
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
|