# Thread: Round down? (Office XP)

1. ## Round down? (Office XP)

How can I get excel to round 87.9 to 87?

2. ## Re: Round down? (Office XP)

=ROUNDDOWN(value,0)

3. ## Re: Round down? (Office XP)

Works like a charm,thanks!

4. ## Re: Round down? (Office XP)

Hi,

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>

5. ## 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. ## 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.)

#### Posting Permissions

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