How do I round a number to the nearest 600 in Excel?

[Guest]

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
(e-mail address removed)

 

[Guest]

Barcelona,

=MROUND(A1,600)

Enjoy.

 

[Bernard Liengme]

Use =MROUND(A1,600)
You need to have the Analysis ToolPac installed to have this function
Otherwise =ROUND(A1/600,0)*600
best wishes

 

[Bob Phillips]

=ROUND(A1/600,0)*600

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Pete_UK]

Alternatively, you could try this:

=IF(CEILING(A1,600)-A1>300,FLOOR(A1,600),CEILING(A1,600))

Hope this helps.

Pete

 

[Bob Phillips]

Bit of overkill isn't it? <G>

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Pete_UK]

Yeah, at first I thought "ceiling", so checked it out to see that I had
the right syntax, then re-read the post and realised the OP wanted to
round OFF to the nearest 600, and one thing led to another ...

Sometimes you get into a fixed mindset !! <bg>

Anyway, it's ONE way of doing it !!

Pete

 

[Guest]

just literally maybe
=MAX((A1<600)*600,ROUND(A1/600,0)*600)
for +/- numbers only

 

[Guest]

disregard the previous
i am confused
maybe with this another overkill
=IF(ABS(A1)<600,SIGN(A1)*600,ROUND(A1/600,0)*600)

 

[Bob Phillips]

Yeah, at first I thought "ceiling", so checked it out to see that I had
the right syntax, then re-read the post and realised the OP wanted to
round OFF to the nearest 600, and one thing led to another ...

Sometimes you get into a fixed mindset !! <bg>

Been there <ebg>