Skip to content

Formula > Functions > Number

number\format

number\format(VALUE, [DECIMALS], [DECIMAL_MARK], [THOUSAND_SEPARATOR])

Converts a numeric VALUE into a string formatted according to a specific format or default application settings. If DECIMALS, DECIMAL_MARK or THOUSAND_SEPARATOR are omitted, then system defaults are used.

Example

number\format(2.666667, 2) – results 2.67;

number\format(1000, 2) – results 1,000.00;

number\format(10.1, 0) – results 10.

number\abs

number\abs(VALUE)

Absolute value. Returns null if VALUE is not numeric.

number\power

number\power(VALUE, EXP)

Raising VALUE to EXP. VALUE and EXP should be int or float. Returns int or float. (as of v8.2)

number\round

number\round(VALUE, PRECISION)

Returns the rounded value of VALUE to specified PRECISION (number of digits after the decimal point). PRECISION can also be negative or zero (default).

number\floor

number\floor(VALUE)

Returns the next lowest integer value by rounding down the value if necessary.

number\ceil

number\ceil(VALUE)

Returns the next highest integer value by rounding up the value if necessary.

number\randomInt

number\randomInt([MIN, MAX])

Generates a cryptographic random integer between specified MIN and MAX. If MIN is omitted, then 0 is used.

number\parseInt

number\parseInt(STRING)

Converts a string to an integer number. (as of v7.1)

number\parseFloat

number\parseFloat(STRING)

Converts a string to a float number. (as of v7.1)