round_upwards

Use the round_upwards function to adjust a number to the indicated precision. If a remaining fractional part would be discarded, the number is adjusted to the next value. This function always adjusts numbers away from zero.

round_upwards ( 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_upwards (12.324; 0) results in 13

round_upwards (12 ; 2) results in 12

round_upwards (12.324; 2) results in 12.33

round_upwards (12.325; 2) results in 12.33

round_upwards (-12.324; 2) results in -12.33

round_upwards (-12.325; 2) results in -12.33