round to the closest five cents

L

lk

I am using Excel 2003

How do you round the contents of a cell to the closest five cents.

Thanks
lk
 

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

Similar Threads

rounding to closest 5 cents 5
rounding currency amounts 4
Rounding cents 4
Organizing a group of notebooks 0
Numaric to Inword in excel by VB 1
Formula to round off number to .95 cents 3
Excel:How do I exactly sum 3 rounded curency numbers 1
Need help modifying code 0

Top