CDBL function

Purpose:

CDBL returns the DOUBLE precision value of a numeric expression.

Syntax:

RetVal = CDBL(Numeric Expression)

Return Value:

Data type: DOUBLE
RetVal is a DOUBLE floating point number.

Parameters:

Numeric Expression Number or calculation.

Remarks:

👉 The BCX CDBL function

rounds positive numbers, with a decimal value greater than or equal to .5, towards positive infinity.
truncates positive numbers with a decimal value less than .5.
rounds negative numbers, with a decimal value less than or equal to -.5, towards negative infinity.
truncates negative numbers with a decimal value more than -.5.

Example:

DIM RetDub#

RetDub# = CDBL(2.538461538461534)
PRINT RetDub#
RetDub# = CDBL(-2.538461538461534)
PRINT RetDub#
?
RetDub# = CDBL(2.538461538461535)
PRINT RetDub#
RetDub# = CDBL(-2.538461538461535)
PRINT RetDub#
?
RetDub# = CDBL(2.538461538461536)
PRINT RetDub#
RetDub# = CDBL(-2.538461538461536)
PRINT RetDub#

Result:

 2.53846153846153
-2.53846153846153

 2.53846153846154
-2.53846153846154

 2.53846153846154
-2.53846153846154

CLDBL function

Purpose:

CLDBL returns the LDOUBLE precision value of a numeric expression.

Syntax:

RetVal = CLDBL(Numeric Expression)

Return Value:

Data type: LDOUBLE
RetVal Floating point number.

Parameters:

Numeric Expression Number or calculation.

Example:

DIM RetDub#
DIM RetLDub AS LDOUBLE

RetDub# = CDBL(6.6 / 2.6)
PRINT RetDub#

RetLDub = CLDBL(6.6 / 2.6)
PRINT RetLDub

Result:

2.53846153846154
2.538461538461538325