Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Confoederatio Helvetica
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding to 0.05 (97+)

    Does anyone have a formula for rounding down to 0.05? We ain't got no pennys in Switzerland!

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Rounding to 0.05 (97+)

    With your value in A1, to round DOWN use <pre> =ROUNDDOWN($A1/0.05,0)*0.05</pre>

    or just to round to the nearest use<pre> =ROUND($A1/0.05,0)*0.05</pre>


    Andrew C

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

    Re: Rounding to 0.05 (97+)

    .. or =FLOOR(cell,0.05)
    -John ... I float in liquid gardens
    UTC -7ąDS

  4. #4
    Silver Lounger
    Join Date
    Jan 2001
    Location
    West Long Branch, New Jersey, USA
    Posts
    1,921
    Thanks
    6
    Thanked 9 Times in 7 Posts

    Re: Rounding to 0.05 (97+)

    There's also an MROUND function in the Analysis Toolpak:
    Returns a number rounded (not rounded down) to the desired multiple.

    From HELP=====
    Syntax
    MROUND(number,multiple)
    ---Number is the value to round.
    ---Multiple is the multiple to which you want to round number.

    Remarks
    MROUND rounds up, away from zero, if the remainder of dividing number by multiple is greater than or equal to half the value of multiple.

    Examples
    MROUND(10, 3) equals 9
    MROUND(-10, -3) equals -9
    MROUND(1.3, 0.2) equals 1.4
    MROUND(5, -2) equals #NUM!
    ====

    So this is truly a rounding function, similar to the other replies but w/o all the work on your part. If you truly want to rounddown, the other answers are just as good as this (which could be made to just rounddown).

    Fred

  5. #5
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Confoederatio Helvetica
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding to 0.05 (97+)

    Thanks to all of you ...

    Problems solved!

Posting Permissions

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