Calculating values to the nearest x

[MCubitt]

I have to work out values to the nearest 16Mb.

So a value of 2 = 16, value of 16 = 16, value of 17 = 32, etc.

I think I need to round up value/16 regardless of the usual rule of .5 is up, otherwise down.

Any ideas, please?




Applications Support
UK

 

[Loomah]

Hi
Have a look at the Ceiling function

Happy Friday

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​