Roundup Help

I

itty

After some calculations i got values like 3,12,6,32 etc. Can sombody
help me to roundup these figures to the nearest multiple of 5
 
P

Paul

itty said:
After some calculations i got values like 3,12,6,32 etc. Can sombody
help me to roundup these figures to the nearest multiple of 5
Click to expand...

For a number in A1, you could use
=CEILING(A1,5)
 
Top