Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Rounding down (2003)

    I have a cell that contains a calculated number and I am trying to display this number in another cell rounded down to the nearest half.

    I have tried MROUND(A1,.5) and that will round to the nearest half but i want to round DOWN. When I use ROUNDDOWN(A1,.5) it rounds to tne nearest whole number and ROUNDDOWN(A1,1) doesn't give me what I want - down to the nearest .5

    Any ideas?

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

    Re: Rounding down (2003)

    Try =INT(2*A1)/2

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Rounding down (2003)

    Hi Don,

    You could use Excel's FLOOR function:
    =FLOOR(A1,5)

    Check out the CEILING for a rounding up equivalent. For both FLOOR and CEILING, the second argument doesn't have to be a whole number, which opens up all sorts of interesting possibilities.

    For a generalised rounding approach you can use:
    =ROUND(A1*n,0)/n
    where 'n' is the multiple that you want to round to. Again, it doesn't matter whether 'n' is a whole number. This approach works equally well with ROUNDUP and ROUNDDOWN too. Leave out the ',0' and it'll even work with INT.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    5 Star Lounger
    Join Date
    Oct 2001
    Location
    San Bernardino, California, USA
    Posts
    734
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding down (2003)

    Thank you both for excellent solutions. Also, I had never heard of FLOOR or CEILING before - they should prove very useful.

Posting Permissions

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