Excel Functions
Collapse the table of content
Expand the table of content

Excel Functions

SQL Server 2000

Excel Functions

Microsoft® SQL Server™ 2000 Analysis Services supports many functions in the Microsoft Excel worksheet library, which is automatically registered if installed on the computer with Analysis Services. Functions not supported in this release are marked by an asterisk in this table.

Acos Acosh And *Application
Asc Asin Asinh Atan2
Atanh AveDev Average BetaDist
BetaInv BinomDist Ceiling ChiDist
ChiInv ChiTest Choose Clean
Combin Confidence Correl Cosh
Count CountA *CountBlank *CountIf
Covar *Creator CritBinom *DAverage
Days360 Db Dbcs *DCount
*DCountA Ddb Degrees DevSq
*DGet *DMax *DMin Dollar
*DProduct *DStDev *DStDevP *DSum
*DVar *DVarP Even ExponDist
Fact FDist Find FindB
FInv Fisher FisherInv Fixed
Floor Forecast *Frequency FTest
Fv GammaDist GammaInv GammaLn
GeoMean *Growth HarMean *HLookup
HypGeomDist *Index Intercept Ipmt
Irr IsErr IsError IsLogical
IsNA IsNonText IsNumber Ispmt
IsText Kurt Large *LinEst
Ln Log Log10 *LogEst
LogInv LogNormDist *Lookup Match
Max *MDeterm Median Min
*MInverse MIrr *MMult Mode
NegBinomDist NormDist NormInv NormSDist
NormSInv NPer Npv Odd
Or *Parent Pearson Percentile
PercentRank Permut Pi Pmt
Poisson Power Ppmt Prob
Product Proper Pv Quartile
Radians *Rank Rate Replace
ReplaceB Rept Roman Round
RoundDown RoundUp RSq Search
SearchB Sinh Skew Sln
Slope Small Standardize StDev
StDevP StEyx Substitute *Subtotal
Sum *SumIf SumProduct SumSq
SumX2MY2 SumX2PY2 SumXMY2 Syd
Tanh TDist Text TInv
Transpose *Trend Trim TrimMean
TTest USDollar Var VarP
Vdb *VLookup Weekday Weibull

© 2016 Microsoft