# Round to 500

This is a discussion on Round to 500 within the Excel Questions forums, part of the Question Forums category; Does anybody have any ideas if it is possble to get excel to round the answer of a formula to ...

1. ## Round to 500

Does anybody have any ideas if it is possble to get excel to round the answer of a formula to the nearest 500.

Thanks

2. ## Re: Round to 500

Try the MROUND function:

=MROUND(A1,500)

3. ## Re: Round to 500

=ROUND(A1/500,0)*500

Replace ROUND with ROUNDUP if you want only round up...

4. ## Re: Round to 500

I believe this does it:

=ROUND(A1/500,0)*500

Edit: man, slow today !

5. ## Re: Round to 500

You could use

or have a look at Mround which requires the analyst tool pak be installed.

6. ## Re: Round to 500

Originally Posted by Juan Pablo González
Edit: man, slow today !
What does that say about me, Juan? :o :D

7. ## Re: Round to 500

Hello guys,

It's a ; not a ,

=Round(A1/500;0)*500

In Excel 2003 it is.

Thanks for the info though.

8. ## Re: Round to 500

Originally Posted by Calendyr
It's a ; not a ,
That is the case in some language versions of Excel, but not in a standard English version, which most board members use.

9. ## Re: Round to 500

Ah that would explain it, I use the French version.

Thanks again!

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•