The following will hopefully save you some time and frustration.  In the examples, [cell ref] refers to the cell reference in Microsoft Excel which contains the number to be rounded.

Making sure the total is correct:  Quite frequently, we sum a column of numbers only to find the total is off by a few cents compared to another source.  Depending on the size of the database, the number can be larger.  To avoid this issue, simply make sure each cell in the column is rounded.  For example, to round to 2 decimal places:  =round([cell ref],2)  To round to the nearest whole dollar:  =round([cell ref], 0).  Even though a number might look right, i.e., $25.36, it may actually be $25.355824.  It’s the extra digits that will throw off the final total.

Rounding to the nearest hundred dollars:  Many worker’s compensation premium calculations are based on each  hundred dollars of payroll.  To calculate this easily in Excel:  =round([cell ref],-2).

Rounding to the nearest thousand dollars:  Life insurance is often rounded to the nearest thousand.  In Excel:  =round([cell ref], -3).

Other rounding:  You’ve already started to see a pattern.  In Excel, you can round to the right of the decimal point by using a positive number.  You can round to the nearest whole dollars (i.e., hundreds, thousands, ten thousand, etc.) by using a negative number.

Hope this helps, but if you have questions or need some clarification, just let me know.  Have fun!