PrecisionCalc
xl Precision
Get Your Numbers Right

xlpDEFAULTMAXSD

Returns the default maximum SD (significant digits) currently in effect.

On editions that allow more than 100 significant digits, xlPrecision prevents inadvertently causing long calculations by defaulting to 100 significant digits unless a custom maximum is specified in the function's maximum_significant_digits parameter. Users can customize that default maximum.

xlpDEFAULTMAXSD() tells you how many maximum significant digits will be returned by an xlPrecision function for which the maximum_significant_digits parameter has been omitted.

Syntax

xlpDEFAULTMAXSD()

Remarks

• You can customize the default maximum significant digits by going to the xlPrecision About box, and clicking on the Set Default Max SD button.

• xlpDEFAULTMAXSD was introduced in xlPrecision 3.0.

Example