rounding

[Keith Partridge]

As we have done away with our 1 & 2 cent coins,
I am trying to round the total of a number of cells to the nearest .05 cents
I've tried the Excel functions but the only way I can do it is:
at A1 enter Heading (Item) B1 enter heading (Price)
A2 to A10 enter Items b2 to B10 enter Prices
A11 enter heading ( Total) B11 enter ( =sum(B2:B10) )
A12 enter heading ( Roundup) B12 enter ( Rounddown)
if total = $145.03 at A13 adjust up 2 cents
if total = $145.02 at B13 adjust down 2 cents
A13 enter heading (Round Total)
B13 enter (=B11+A13-B13)

I would like an answer as to an easier method to do this.


Keith

 

[Jerry W. Lewis]

Use either
=MROUND(x,0.05)
or
=ROUND(x*20,0)/20

Jerry

 

[Keith Partridge]

Thanks Jerry
Keith

Use either
=MROUND(x,0.05)
or
=ROUND(x*20,0)/20

Jerry