XL: List of Available Worksheet Functions

• 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()