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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
Use =MROUND(A1,600)
You need to have the Analysis ToolPac installed to have this function
Otherwise =ROUND(A1/600,0)*600
best wishes
 
Alternatively, you could try this:

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

Hope this helps.

Pete
 
Bit of overkill isn't it? <G>

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
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
 
disregard the previous
i am confused
maybe with this another overkill
=IF(ABS(A1)<600,SIGN(A1)*600,ROUND(A1/600,0)*600)
 
Pete_UK said:
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>
Click to expand...


Been there <ebg>
 
Back
Top