How can I round a number to the nearest "50" or "100" in excel 200
 

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

what to do with 75?

"Manny" schreef in bericht
...
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

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