Round down? (Office XP)

Topic

New Reply

How can I get excel to round 87.9 to 87?

Reply | Quote

Replies

=ROUNDDOWN(value,0)

Reply | Quote

Works like a charm,thanks!

Reply | Quote

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.

Reply | Quote

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 =MROUND(A1,0.25). And to round to the nearest multiple of 0.05, use =MROUND(A1,0.05).

Reply | Quote

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 =MROUND(A1,0.25). And to round to the nearest multiple of 0.05, use =MROUND(A1,0.05).

Reply | Quote

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.

Reply | Quote

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

Reply | Quote

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

Reply | Quote

Works like a charm,thanks!

Reply | Quote

=ROUNDDOWN(value,0)

Reply | Quote