PrecisionCalc
xl Precision
Get Your Numbers Right

xlpSD

Returns the SD (significant digits) edition of xlPrecision.

Syntax

xlpSD()

Remarks

• The value returned by xlpSD is the maximum number of significant digits that can be returned.

• Values returned by xlpSD range from 25 to 2,147,483,648.

• The Free Edition of xlPrecision 3.0 and later returns 500. The Free Edition of xlPrecision 2.x returns 150.

• The SD edition can also be viewed on the About box. From Excel's Tools menu, choose xlPrecision | About xlPrecision.

• xlpSD was introduced in xlPrecision 2.0.

Example