| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data gets rounded up !!! | Excel Discussion (Misc queries) | |||
| Ensuring 3 cells do NOT match | Excel Discussion (Misc queries) | |||
| numbers being rounded | New Users to Excel | |||
| how do i add rounded numbers? | Excel Discussion (Misc queries) | |||
| Ensuring deleted data cannot be recovered | Excel Discussion (Misc queries) | |||
Threaded Mode
