Bit of overkill isn't it? <G

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Pete_UK" wrote in message
oups.com...
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 -