In article ,
says...
I have a odd number and would like to round it off the nearest 50 or 100
whichever is closer. Can that be done? If yes how. Thanks

Since 100 is a multiple of 50, just round to 50. It will yield the
necessary result. If the number of interest is in A1, use
=ROUND(A1/50,0)*50.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions