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

R

Raina

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

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
 
J

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top