Function 02)

02) Add Function APPLYROUNDING to active workbook

This function systematically allocates rounding errors to specific rows. While this was developed for use on Tract Participation calculations it could also be used for a single set of calculations that should add to a certain value.

For instance, if a group of calculated rows should add to 100%, such as the case with division order decks, then this function could be used to allocate any rounding error back to individual rows. The allocation is based first on the row’s rounding error, then on the row’s original decimal, and finally on the row’s relative position to the other rows.

The function takes 6 arguments:

=ApplyRounding ( GroupRange , GroupRoundingError , GroupItem , ItemRoundingError , ItemOriginalDecimal , DecimalsRoundTo)

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc