Rounding to Multiples of Five

An Excel file that teaches how to perform Rounding to Multiples of Five operation.

Excel Source: Rounding to Multiples of Five

The ROLL DOWN and ROLL UP functions are being compared. Multiple layers are determined by parameters. Negative numbers are processed correctly. Intermediate results are stored in the control column. Final values are printed to the report.

Hope it is useful.