Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103750

From BetaArchive Wiki

XL: List of Available Worksheet Functions



The information in this article applies to:


  • Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0
  • Microsoft Excel for the Macintosh, versions 4.0, 5.0





SUMMARY

The following are the 307 worksheet functions available in Microsoft Excel. This list also includes the functions that are added when you load the add- in macros ADDINFNS.XLA, ANALYSF.XLA, and CROSSFNC.XLA.



MORE INFORMATION

ABS()

   ACCRINT()
   ACCRINTM()
   ACOS()
   ACOSH()
   ADDRESS()
   AND()
   AREAS()
   ASIN()
   ASINH()
   ATAN()
   ATAN2()
   ATANH()
   AVEDEV()
   AVERAGE()
   BASE() NOTE: Not available in Excel version 5.0
   BESSELI()
   BESSELJ()
   BESSELK()
   BESSELY()
   BETADIST()
   BETAINV()
   BIN2DEC()
   BIN2HEX()
   BIN2OCT()
   BINOMDIST()
   CEILING()
   CELL()
   CHAR()
   CHIDIST()
   CHIINV()
   CHITEST()
   CHOOSE()
   CLEAN()
   CODE()
   COLUMN()
   COLUMNS()
   COMBIN()
   COMPLEX()
   CONFIDENCE()
   CONVERT()
   CORREL()
   COS()
   COSH()
   COUNT()
   COUNTA()
   COUPDAYBS()
   COUPDAYS()
   COUPDAYSNC()
   COUPNCD()
   COUPNUM()
   COUPPCD()
   COVAR()
   CRITBINOM()
   CROSSTAB()
   CUMIPMT()
   CUMPRINC()
   DATE()
   DATEVALUE()
   DAVERAGE()
   DAY()
   DAYS360()
   DB()
   DCOUNT()
   DCOUNTA()
   DDB()
   DEC2BIN()
   DEC2HEX()
   DEC2OCT()
   DEGREES()
   DELTA()
   DEVSQ()
   DGET()
   DISC()
   DMAX()
   DMIN()
   DOLLAR()
   DOLLARDE()
   DOLLARFR()
   DPRODUCT()
   DSTDEV()
   DSTDEVP()
   DSUM()
   DURATION()
   DVAR()
   DVARP()
   EDATE()
   EFFECT()
   EOMONTH()
   ERF()
   ERFC()
   ERROR.TYPE()
   EVEN()
   EXACT()
   EXP()
   EXPONDIST()
   FACT()
   FACTDOUBLE()
   FALSE()
   FASTMATCH()
   FDIST()
   FIND()
   FINV()
   FISHER()
   FISHERINV()
   FIXED()
   FLOOR()
   FORECAST()
   FREQUENCY()
   FTEST()
   FV()
   FVSCHEDULE()
   GAMMADIST()
   GAMMAINV()
   GAMMALN()
   GCD()
   GEOMEAN()
   GESTEP()
   GROWTH()
   HARMEAN()
   HEX2BIN()
   HEX2DEC()
   HEX2OCT()
   HLOOKUP()
   HOUR()
   HYPGEOMDIST()
   IF()
   IMABS()
   IMAGINARY()
   IMARGUMENT()
   IMCONJUGATE()
   IMCOS()
   IMDIV()
   IMEXP()
   IMLN()
   IMLOG10()
   IMLOG2()
   IMPOWER()
   IMPRODUCT()
   IMREAL()
   IMSIN()
   IMSQRT()
   IMSUB()
   IMSUM()
   INDEX()
   INDIRECT()
   INFO()
   INT()
   INTERCEPT()
   INTRATE()
   IPMT()
   IRR()
   ISBLANK()
   ISERR()
   ISERROR()
   ISEVEN()
   ISLOGICAL()
   ISNA()
   ISNONTEXT()
   ISNUMBER()
   ISODD()
   ISREF()
   ISTEXT()
   KURT()
   LARGE()
   LCM()
   LEFT()
   LEN()
   LINEST()
   LN()
   LOG()
   LOG10()
   LOGEST()
   LOGINV()
   LOGNORMDIST()
   LOOKUP()
   LOWER()
   MATCH()
   MAX()
   MDETERM()
   MDURATION()
   MEDIAN()
   MID()
   MIN()
   MINUTE()
   MINVERSE()
   MIRR()
   MMULT()
   MOD()
   MODE()
   MONTH()
   MROUND()
   MULTINOMIAL()
   N()
   NA()
   NEGBINOMDIST()
   NETWORKDAYS()
   NOMINAL()
   NORMDIST()
   NORMINV()
   NORMSDIST()
   NORMSINV()
   NOT()
   NOW()
   NPER()
   NPV()
   OCT2BIN()
   OCT2DEC()
   OCT2HEX()
   ODD()
   ODDFPRICE()
   ODDFYIELD()
   ODDLPRICE()
   ODDLYIELD()
   OFFSET()
   OR()
   PEARSON()
   PERCENTILE()
   PERCENTRANK()
   PERMUT()
   PI()
   PMT()
   POISSON()
   PPMT()
   PRICE()
   PRICEDISC()
   PRICEMAT()
   PROB()
   PRODUCT()
   PROPER()
   PV()
   QUARTILE ()
   QUOTIENT()
   RADIANS()
   RAND()
   RANDBETWEEN()
   RANK()
   RATE()
   RECEIVED()
   REPLACE()
   REPT()
   RIGHT()
   ROUND()
   ROW()
   ROWS()
   RSQ()
   SEARCH()
   SECOND()
   SERIESSUM()
   SIGN()
   SIN()
   SINH()
   SKEW()
   SLN()
   SLOPE()
   SMALL()
   SQRT()
   SQRTPI()
   STANDARDIZE()
   STDEV()
   STDEVP()
   STEYX()
   SUBSTITUTE()
   SUM()
   SUMPRODUCT()
   SUMSQ()
   SUMX2MY2()
   SUMX2PY2()
   SUMXMY2()
   SYD()
   T()
   TAN()
   TANH()
   TBILLEQ()
   TBILLPRICE()
   TBILLYIELD()
   TDIST()
   TEXT()
   TIME()
   TIMEVALUE()
   TINV()
   TODAY()
   TRANSPOSE()
   TREND()
   TRIM()
   TRIMMEAN()
   TRUE()
   TRUNC()
   TTEST()
   TYPE()
   UPPER()
   VALUE()
   VAR()
   VARP()
   VDB()
   VLOOKUP()
   WEEKDAY()
   WEIBULL()
   WORKDAY()
   XIRR()
   XNPV()
   YEAR()
   YEARFRAC()
   YIELD()
   YIELDDISC()
   YIELDMAT()
   ZTEST() 

Additional query words: 4.00a toolpack tool pack pak dialog box

Keywords :
Version : WINDOWS: 4.0, 4.0a, 5.0; MACINTOSH: 4.0, 5.0
Platform : MACINTOSH WINDOWS
Issue type :
Technology :


Last Reviewed: April 6, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.