MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to round currency figures to nearest 5 cents?


Posted by Thor on November 19, 2000 6:54 PM

How to round currency figures to nearest 5 cents?


Posted by Jimmy on November 20, 2000 6:12 AM

Try this, I think it will get you what you want.
Cells A1:A3 is the data you enter, the formula will go in A4. Of course you can adjust the cells to what ever you need.

=MROUND(AVERAGE(A1:C1),0.05)

Posted by Jimmy on November 20, 2000 11:22 AM

I was assuming you was averaging, if not just drop the (average(A1:C1)
=MROUND(A1,0.05)