Rounding and random numbers

Functions that round a number or produce a random one. All of them return a double. Other arithmetic functions are on Mathematical functions.

ROUND#

ROUND rounds a number to the nearest whole number; a half is rounded away from zero (2.5 to 3, -2.5 to -3).

1

ROUND(number)

Remarks — ROUND has no argument for decimal places. To round to one decimal place, multiply by 10, round and divide by 10; use 100 for two places.

Example

ROUND(2.49);
# Result: 2
ROUND(2.5);
# Result: 3
ROUND(-2.5);
# Result: -3
ROUND(21.46 * 10) / 10;
# Result: 21.5

CEIL#

CEIL rounds a number up to the next whole number, or to the next multiple of significance when it is given.

1
2

CEIL(number)
CEIL(number, significance)

Parameters

Remarks — With a positive significance the result moves towards plus infinity, so a negative number moves towards zero (CEIL(-22.25, 1) is -22). With a negative significance a negative number moves away from zero (CEIL(-22.25, -1) is -23).

Example

Errors — Significance cannot be 0.; Significance cannot be negative value if a number is a positive value.

FLOOR#

FLOOR rounds a number down to the previous whole number, or to the previous multiple of significance when it is given.

1
2

FLOOR(number)
FLOOR(number, significance)

Parameters and Errors are the same as for CEIL.

Remarks — With a positive significance the result moves towards minus infinity, so a negative number moves away from zero (FLOOR(-22.25, 1) is -23). With a negative significance a negative number moves towards zero (FLOOR(-22.25, -1) is -22).

Example

A whole-number division, for example days from seconds:

VAR uptime := 200000;
FLOOR(uptime / 86400);
# Result: 2

RAND#

RAND returns a random number from 0 up to, but not including, 1; every call gives a new value.

1

RAND()

Example

RAND() * 100;
# Result: a random number from 0 to just below 100

RANDINT#

RANDINT returns a random whole number from min up to, but not including, max.

1

RANDINT(min, max)

Returns — double holding a whole number. Use whole numbers for both limits: with a decimal min the result can be lower than min.

Example

RANDINT(1, 7);
# Result: 1, 2, 3, 4, 5 or 6