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

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        : 

Last Reviewed: April 6, 1999