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

B

Barcelona

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
[email protected]
 
B

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
 
B

Bob Phillips

=ROUND(A1/600,0)*600

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
P

Pete_UK

Alternatively, you could try this:

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

Hope this helps.

Pete
 
B

Bob Phillips

Bit of overkill isn't it? <G>

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
P

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
 
D

driller

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

Bob Phillips

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>
 
Top