Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Rounding to 1/4 cent

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I wish to round linked volumes to the nearest .0025. Help please.

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =MROUND(A1,.0025)

    This requires the analysis tool pack

  3. #3
    Guest

    Default

    Can you make do with the Ceiling function.

    i.e. =CEILING(A1,0.0025) ???

  4. #4
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ceiling only rounds UP, not to the nearest.

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The MROUND tack returns a #NUM! error

  6. #6
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you have the analysis ToolPack installed?

  7. #7
    New Member
    Join Date
    Feb 2002
    Location
    Dallas, TX
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Fixed. Note: If the number being evaluated is less than 0, you must put a -.0025

    Argument works thusly:

    =IF(A1<0,MROUND(A1,-.0025),MROUND(A1,.0025))

    Thanks for the help.

  8. #8
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank YOU! I didn't know that and I didn't even consider negative numbers.

Some videos you may like

User Tag List

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
  •