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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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?
Click to expand...

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.
 
Back
Top