Thread: How do I round a number to the nearest 600 in Excel?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How do I round a number to the nearest 600 in Excel?
Use =MROUND(A1,600)
You need to have the Analysis ToolPac installed to have this function
Otherwise =ROUND(A1/600,0)*600
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Barcelona" wrote in message
...
I need to round numbers to the nearest multiple of 600. For example if the
number is 15,443, I am looking for a formula that would round the number
to
15,600. Is there one?

Judy Sanchez



Reply With QuoteReply With Quote