Alternatively, you could try this:

=IF(CEILING(A1,600)-A1300,FLOOR(A1,600),CEILING(A1,600))

Hope this helps.

Pete


On Jan 25, 5:23 pm, "Bernard Liengme"
wrote:
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 Liengmewww.stfx.ca/people/bliengme
remove caps from email

"Barcelona" wrote in ...



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
- Hide quoted text -- Show quoted text -