Results 1 to 9 of 9

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. #1
    New Member
    Join Date
    Feb 2003
    Posts
    14

    Default 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. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    27,134

    Default Re: Round to 500

    Try the MROUND function:

    =MROUND(A1,500)
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    64,853

    Default Re: Round to 500

    =ROUND(A1/500,0)*500

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

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,950

    Default Re: Round to 500

    I believe this does it:

    =ROUND(A1/500,0)*500

    Edit: man, slow today !
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  5. #5
    IML
    IML is offline
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,744

    Default Re: Round to 500

    You could use
    =ROUND(your formula/500,0)*500

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

  6. #6
    IML
    IML is offline
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,744

    Default Re: Round to 500

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

  7. #7
    New Member
    Join Date
    Sep 2010
    Posts
    2

    Default 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. #8
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    26,068

    Default Re: Round to 500

    Quote Originally Posted by Calendyr View Post
    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.
    Hope this helps, good luck.
    Peter

    - Read: Posting Guidelines, Forum Rules & FAQs
    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste (To test: Test Here)
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker

  9. #9
    New Member
    Join Date
    Sep 2010
    Posts
    2

    Default Re: Round to 500

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

    Thanks again!

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com