Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Round down? (Office XP)

    How can I get excel to round 87.9 to 87?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Round down? (Office XP)

    =ROUNDDOWN(value,0)
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Round down? (Office XP)

    Works like a charm,thanks!
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Round down? (Office XP)

    Hi,
    Here is some more info about rounding...just for your information!

    It is possible to round a Rand amount to the nearest 25 cents? For example, if a number appears as R1.65, it can be converted it to R1.75. Excel's ROUND () function just needs to be adapted slightly because it only works with whole numbers.

    The following formula, which assumes that your value is in cell A1, will do the job for you.
    =ROUND (A1/.25, 0)*.25

    The formula divides the original value by .25 and then multiplies the result by .25. You can, of course, use a similar formula to round values to other fractions. For example, to round a Rand amount to the nearest nickel, simply substitute .05 for each of the two occurrences of ".25" in the preceding formula.

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Regards,
    Rudi

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Round down? (Office XP)

    This is not related to the original question, but to Rudi's reply. If you install the Analysis ToolPak add-in (Tools | Add-Ins...), you can use the MROUND function to round to the nearest multiple of a specified number.

    To round A1 to the nearest multiple of 0.25, use <code>=MROUND(A1,0.25)</code>. And to round to the nearest multiple of 0.05, use <code>=MROUND(A1,0.05)</code>.

  6. #6
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Round down? (Office XP)

    In addition to the advice in Rudi and Hans discussion, you might also want to investigate ROUNDUP(), INT(), CEILING(), FLOOR(), TRUNC() and ABS(). (Some may be in the Analysis Toolpack.)
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

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