Rounding in Excel

[tullocks]

I need to round a column of dollar amounts to the nearest .*9.
Examples: round .64 down to .59; round 5.00 down to 4.99; round .76 up to .79.
Is there a way to do this?

 

[giacomo]

On 2002-04-04 10:34, tullocks wrote:
I need to round a column of dollar amounts to the nearest .*9.
Examples: round .64 down to .59; round 5.00 down to 4.99; round .76 up to .79.
Is there a way to do this?

if the number to round is in cell A1 use =MROUND(A1,0.1)-0.01

you need to have the Analysis Toolpak installed to use MROUND()

 

[Mark W.]

=ROUND(A1,1)-0.01

...will work too! And, you won't need the Analysis Tookpak.

 

[Jay Petrulis]

On 2002-04-04 11:21, Mark W. wrote:
=ROUND(A1,1)-0.01

...will work too! And, you won't need the Analysis Tookpak.

Cool! Very nice. Short and simple --> the best kind of answer.