_Workbook.AccuracyVersion _Workbook.AccuracyVersion _Workbook.AccuracyVersion Property

Definition

Gets or sets whether certain worksheet functions use the latest accuracy algorithms to calculate their results.

public:
 property int AccuracyVersion { int get(); void set(int value); };
public int AccuracyVersion { get; set; }
Public Property AccuracyVersion As Integer

Property Value

Specifies which version of algorithms to use for certain worksheet functions.

Remarks

Read/write

By default, some of the worksheet functions from Microsoft Office Excel 2007 and earlier versions of Microsoft Excel use new algorithms that increase their accuracy. However, in some cases, the new algorithms decrease the performance of these functions relative to their performance in Microsoft Office Excel 2007 and earlier versions of Excel. To specify that these worksheet functions use the older algorithms to increase their performance, set the AccuracyVersion property to 1. The following table describes the possible settings for the AccuracyVersion property.

0Use the latest, most accurate algorithms (default)
1Use Microsoft Office Excel 2007 or earlier version algorithms
2Use Microsoft Excel 2010 algorithms

Caution: Setting the AccuracyVersion property to a value other than 0, 1, or 2 will result in undefined behavior.

The following table summarizes which functions are affected by setting the AccuracyVersion property to 1. The functions that are listed in the "Functions not affected" column will always use the latest accuracy algorithms or were not changed in Excel 2010. For function names that include a period (.) in their names, to determine the name of the corresponding function implemented in VBA as a method of the WorksheetFunction object, substitute the underscore character ( _ ) for the period. For example, the VBA method that corresponds to the BETA.DIST function is the Beta_Dist(Double, Double, Double, Boolean, Object, Object) method.

BETADISTAGGREGATE
BETAINVBETA.DIST
BINOMDISTBETA.INV
CHIDISTBINOM.DIST
CHIINVBINOM.INV
CHITESTCEILING
CONFIDENCECEILING.PRECISE
CRITBINOMCHISQ.DIST
CUMIPMTCHISQ.DIST.RT
CUMPRINCCHISQ.INV
ERFCHISQ.INV.RT
ERFCCHISQ.TEST
EXPONDISTCONFIDENCE.NORM
FDISTCONFIDENCE.T
FINVCOVAR
FTESTCOVARIANCE.P
GAMMADISTCOVARIANCE.S
GAMMALNERF.PRECISE
GAMMINVERFC.PRECISE
HYPGEOMDISTEXPON.DIST
IPMTF.DIST
IRRF.DIST.RT
LOGINVF.INV
LOGNORMDISTF.INV.RT
NEGBINOMDISTF.TEST
NORMDISTFLOOR
NORMINVFLOOR.PRECISE
NORMSDISTGAMMA.DIST
NORMSINVGAMMA.INV
PMTGAMMALN.PRECISE
POISSONHYPGEOM.DIST
PPMTISO.CEILING
STDEVLOGNORM.DIST
STDEVPLOGNORM.INV
TDISTMOD
TINVMODE
TTESTMODE.MULT
VARMODE.SNGL
VARANEGBINOM.DIST
VARPNETWORKDAYS.INTL
VARPANORM.DIST
WEIBULLNORM.INV
XIRRNORM.S.DIST
ZTESTNORM.S.INV
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
POISSON.DIST
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
RANK.AVG
RANK.EQ
STDEV.P
STDEV.S
T.DIST
T.DIST.2T
T.DIST.RT
T.DIST.RT
T.INV
T.INV.2T
T.INV.RT
T.TEST
VAR.P
VAR.S
WEEKDAY
WEEKNUM
WEIBULL.DIST
WORKDAY.INTL
Z.TEST

Applies to