Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jul 2002
    Location
    CALIFORNIA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding to nearest .125 (Excel 2003)

    Hello,

    Is there an easy way to round a cell to the nearest .125 value.

    Example:
    5.655% displayed as 5.625%

    Thanks..
    Shaun

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Rounding to nearest .125 (Excel 2003)

    Hi Shaun

    If you have the Analysis Toolpak add-in installed you can use:

    <code><big>=MROUND(A1,0.125%)</big></code>

    Without the Analysis Toolpak:

    <code><big>=ROUND(A1*800,0)/800</big></code>

  3. #3
    New Lounger
    Join Date
    Jul 2002
    Location
    CALIFORNIA
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding to nearest .125 (Excel 2003)

    Thanks...MROUND was exactly what I needed.

    I had tried to use the MROUND function but it wasn't working. I wasn't putting the % sign in the formula. That appears to be the missing piece.

    Appreciate the help.

    Shaun

Posting Permissions

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