Workbook.AccuracyVersion Property

Definition

Specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results.

public int AccuracyVersion { get; set; }

Property Value

A value that specifies whether certain worksheet functions use the latest accuracy algorithms to calculate their results.

Exceptions

This property is used in an Excel 2007 project.

Remarks

By default, some of the worksheet functions from Excel 2007 and earlier versions of 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 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.

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

Note

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 method.

Functions affected Functions not affected
BETADIST AGGREGATE
BETAINV BETA.DIST
BINOMDIST BETA.INV
CHIDIST BINOM.DIST
CHIINV BINOM.INV
CHITEST CEILING
CONFIDENCE CEILING.PRECISE
CRITBINOM CHISQ.DIST
CUMIPMT CHISQ.DIST.RT
CUMPRINC CHISQ.INV
ERF CHISQ.INV.RT
ERFC CHISQ.TEST
EXPONDIST CONFIDENCE.NORM
FDIST CONFIDENCE.T
FINV COVAR
FTEST COVARIANCE.P
GAMMADIST COVARIANCE.S
GAMMALN ERF.PRECISE
GAMMINV ERFC.PRECISE
HYPGEOMDIST EXPON.DIST
IPMT F.DIST
IRR F.DIST.RT
LOGINV F.INV
LOGNORMDIST F.INV.RT
NEGBINOMDIST F.TEST
NORMDIST FLOOR
NORMINV FLOOR.PRECISE
NORMSDIST GAMMA.DIST
NORMSINV GAMMA.INV
PMT GAMMALN.PRECISE
POISSON HYPGEOM.DIST
PPMT ISO.CEILING
STDEV LOGNORM.DIST
STDEVP LOGNORM.INV
TDIST MOD
TINV MODE
TTEST MODE.MULT
VAR MODE.SNGL
VARA NEGBINOM.DIST
VARP NETWORKDAYS.INTL
VARPA NORM.DIST
WEIBULL NORM.INV
XIRR NORM.S.DIST
ZTEST NORM.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

Note

This property appears in IntelliSense in Excel 2007 projects that target the .NET Framework 4. However, this property cannot be used in Excel 2007 projects.

Applies to