How do I get a calculated amount to round to the nearest nickel?

[Guest]

I have an excel spreadsheet with a column of calculated dollar & cent
amounts. Is there a way to get the calculation (in Excel 2003) to round up to
the nearest nickel increment? or just round to the nearest nickel increment?

 

[T. Valko]

To round up to the next 0.05:

=CEILING(A1,0.05)

To round to the nearest 0.05:

=ROUND(A1/0.05,0)*0.05

 

[joeu2004]

I have an excel spreadsheet with a column of calculated dollar & cent
amounts. Is there a way to get the calculation (in Excel 2003) to round up to
the nearest nickel increment? or just round to the nearest nickel increment?

Round up: =ceiling(A1, 0.05)

Round down: =floor(A1, 0.05)

Round: =mround(A1, 0.05)
or: =0.05 * round(A1/0.05, 0)

If MROUND causes a #NAME? error, refer to the MROUND Help page to see
how to install the Analysis TookPak. But you might want to avoid the
ATP.

 

[Bernd P]

Hello,

I suggest to do the rounding part this way:
=ROUND(A1*2,1)/2

Regards,
Bernd