1. ## 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. ## Re: Rounding down (2003)

Try =INT(2*A1)/2

3. ## 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

4. ## 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
•