round

Use the round function to round a number to the nearest value with the indicated precision using the commercial rounding rule.

round (input; precision)

This function returns a value of type NUMBER.

The function has two parameters:

1. input, type NUMBER. The number to round.
2. precision, type NUMBER. The number of significant decimals (up to 9 decimals is supported).

This function treats positive and negative values symmetrically.

Examples

round (12.324; 0) results in 12

round (12; 2) results in 12

round (12.324; 2) results in 12.32

round (12.325; 2) results in 12.33

round (-12.324; 2) results in -12.32

round (-12.325; 2) results in -12.33