I have an excel spreadsheet I use once a year so its time to adjust for the lose of pennies in Canada.

I have read about the MROUND function but am unclear how to use it?

For example on one sheet for say "Joe" I enter a column of numbers (2 decimal places is currently used as it a cost) At the page bottom I total that column and eventually move that total to a second sheet. I want that total at the bottom of the first sheet to be rounded up or down to the nearest nickel, and displayed that way, before the value is used on the second sheet.

The formula for the total at the bottom of the first sheet is just the sum of a range of cells

=SUM(D5:D19)

How do I make that displayed total show as rounded to the nearest nickel??

Thanks Doug