According to your examples, you want to round to the nearest 0.05 (not the
nearest 5).
To round to the nearest 0.05, use the formula:
=ROUND(A1/0.05,0)*0.05
To round to the nearest 5, use the formula:
=ROUND(A1/5,0)*5
--ron
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.