+ Reply to Thread
Results 1 to 6 of 6

Formula for dividing and rounding a number with multiples of 500

  1. #1
    Registered User
    Join Date
    05-12-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    3

    Formula for dividing and rounding a number with multiples of 500

    Hi to all,

    I'm new here and I would like to ask you guys for some help solving this problem. Here we go

    I would like to have a formula that could divide a number in 4 and could give me the result rounded down in multiples of five hundred, as an example:

    - 13000 / 4 = 3250 the result that i would like to obtain rounded would be 3000
    - 7250 / 4 = 1812,5 the result that i would like to obtain rounded would be 1500

    Is it possible to make a formula for that?

    Thanks in advanced,

    Best Regards,

    Mojito

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Formula for dividing and rounding a number with multiples of 500

    With a number in A1
    This regular formula does what you're asking
    B1: =FLOOR(A1/4,500)

    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula for dividing and rounding a number with multiples of 500

    Hi,

    Welcome to the forum.

    One way

    =(A1/4)-MOD(A1/4,500)
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    05-12-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula for dividing and rounding a number with multiples of 500

    Hi to All,

    Thank you for you replies but i'm not being able to get the formula to work.

    In attachement you'll be able to see the table... When I try the above formulas it says that I've entered too few arguments fot the function.

    This might be a noob problem lol

    Thks again,

    Mojito
    Attached Files Attached Files

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Formula for dividing and rounding a number with multiples of 500

    Hi,

    Are you entering them EXACTLY as suggested.

    Both work but Ron's is neater being smaller.

  6. #6
    Registered User
    Join Date
    05-12-2012
    Location
    Lisbon
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Formula for dividing and rounding a number with multiples of 500

    Its working Thanks a million!!! You guys made my day.

    Best Regards,

    Mojito

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1