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)
