Concept: Rounding with Formulas

To round a value with decimals to the nearest whole number, you can use the Round function. The Round function rounds the number up or down.

Example: Round(ACCT.001).

Value of ACCT.001:	Formula Returns:
3.45	3
7.798	8

Truncating removes numbers after the decimal. The function effectively always rounds down to the nearest whole number.

Example: Trunc(ACCT.001).

To round to the 10s place, or the 100s place, and so on, you can use the Round functions in advanced formulas.

Example: Round(divf(ACCT.001,10))*10.

The formula says: First divide the value by 10, then round the result to the nearest whole number. Finally multiply the result by 10.

To round to the nearest 100, replace both 10s with 100. To round the nearest 1000, replace both 10s with 1000, and so on. You can also round to numbers after the decimal. To round the nearest 10th, replace the 10s with .1. To round to the 100th place, replace the 10s with .01 and so on.

To truncate to the nearest 10s, or the nearest 100s, and so on, you can use the Trunc function in advanced formulas.

Example: Trunc(divf(ACCT.001,10))*10.

The formula says: Divide the account by 10. Then, truncate the result. Finally, multiply the result by 10.

To truncate to the 100s, replace both 10s with 100. To truncate to the 1000s, replace both 10s with 1000, and so on.  You can also truncate to numbers after the decimal. To round the nearest 10th, replace the 10s with .1. To round to the 100th place, replace the 10s with .01 and so on.