Get Your Numbers Right
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.
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.
|=xlpDEFAULTMAXSD()||Default maximum SD (significant digits) currently in effect.|