Truncate

Description

Truncates a number to the specified number of decimal places.

Syntax

Truncate ( x,  n )

Argument

Description

x

The number you want to truncate.

n

The number of decimal places to which you want to truncate x. Valid values are 0 through 28.


Return value

The datatype of x. If n is positive, returns x truncated to the specified number of decimal places. If n is negative, returns x truncated to (- n +1) places before the decimal point. Returns -1 if it fails.

Examples

This expression returns 9.2:

Truncate(9.22, 1)

This expression returns 9.2:

Truncate(9.28, 1)

This expression returns 9:

Truncate(9.9, 0)

This expression returns -9.2:

Truncate(-9.29, 1)

This expression returns 0:

Truncate(9.2, -1)

This expression returns 50:

Truncate(54, -1)

See also

Ceiling

Int

Round