Microsoft KB Archive/106464

{| = Excel: Add-in Files and Their Associated Functions =
 * width="100%"|

Last reviewed: September 12, 1996

Article ID: Q106464 The information in this article applies to:
 * Microsoft Excel for Windows, version 4.0, 4.0a

SUMMARY
If you receive the #NAME? error value after you enter a function, you should verify that the correct add-in file is loaded. To do this, use the following list to locate and reopen the associated file.

The following is a complete list of all of the Microsoft Excel version 4.0 and 4.0a add-in functions and command macros, and their associated filenames and default locations.

Function           Contained in File                 Function Type ACCRINT            \LIBRARY\ANALYSIS\analysf.xla     Custom Function ACCRINTM           \LIBRARY\ANALYSIS\analysf.xla     Custom Function ANOVA1             \LIBRARY\ANALYSIS\analysis.xla    Command Macro ANOVA2             \LIBRARY\ANALYSIS\analysis.xla    Command Macro ANOVA3             \LIBRARY\ANALYSIS\analysis.xla    Command Macro BASE               \LIBRARY\addinfns.xla             Custom Function BESSELI            \LIBRARY\ANALYSIS\analysf.xla     Custom Function BESSELJ            \LIBRARY\ANALYSIS\analysf.xla     Custom Function BESSELK            \LIBRARY\ANALYSIS\analysf.xla     Custom Function BESSELY            \LIBRARY\ANALYSIS\analysf.xla     Custom Function BIN2DEC            \LIBRARY\ANALYSIS\analysf.xla     Custom Function BIN2HEX            \LIBRARY\ANALYSIS\analysf.xla     Custom Function BIN2OCT            \LIBRARY\ANALYSIS\analysf.xla     Custom Function COMPLEX            \LIBRARY\ANALYSIS\analysf.xla     Custom Function CONVERT            \LIBRARY\ANALYSIS\analysf.xla     Custom Function COUPDAYBS          \LIBRARY\ANALYSIS\analysf.xla     Custom Function COUPDAYS           \LIBRARY\ANALYSIS\analysf.xla     Custom Function COUPDAYSNC         \LIBRARY\ANALYSIS\analysf.xla     Custom Function COUPNCD            \LIBRARY\ANALYSIS\analysf.xla     Custom Function COUPNUM            \LIBRARY\ANALYSIS\analysf.xla     Custom Function COUPPCD            \LIBRARY\ANALYSIS\analysf.xla     Custom Function CREATE.DIRECTORY   \LIBRARY\filefns.xla              Custom Function CROSSTAB           \LIBRARY\CROSSTAB\crossfnc.xla    Custom Function CUMIPMT            \LIBRARY\ANALYSIS\analysf.xla     Custom Function CUMPRINC           \LIBRARY\ANALYSIS\analysf.xla     Custom Function DEC2BIN            \LIBRARY\ANALYSIS\analysf.xla     Custom Function DEC2HEX            \LIBRARY\ANALYSIS\analysf.xla     Custom Function DEC2OCT            \LIBRARY\ANALYSIS\analysf.xla     Custom Function DEGREES            \LIBRARY\addinfns.xla             Custom Function DELETE.DIRECTORY   \LIBRARY\filefns.xla              Custom Function DELTA              \LIBRARY\ANALYSIS\analysf.xla     Custom Function DESCR              \LIBRARY\ANALYSIS\analysis.xla    Command Macro DIRECTORIES        \LIBRARY\filefns.xla              Custom Function DISC               \LIBRARY\ANALYSIS\analysf.xla     Custom Function DOLLARDE           \LIBRARY\ANALYSIS\analysf.xla     Custom Function DOLLARFR           \LIBRARY\ANALYSIS\analysf.xla     Custom Function DURATION           \LIBRARY\ANALYSIS\analysf.xla     Custom Function EDATE              \LIBRARY\ANALYSIS\analysf.xla     Custom Function EFFECT             \LIBRARY\ANALYSIS\analysf.xla     Custom Function EOMONTH            \LIBRARY\ANALYSIS\analysf.xla     Custom Function ERF                \LIBRARY\ANALYSIS\analysf.xla     Custom Function ERFC               \LIBRARY\ANALYSIS\analysf.xla     Custom Function EXPON              \LIBRARY\ANALYSIS\analysis.xla    Command Macro FACTDOUBLE         \LIBRARY\ANALYSIS\analysf.xla     Custom Function FASTMATCH          \LIBRARY\addinfns.xla             Custom Function FILE.EXISTS        \LIBRARY\filefns.xla              Custom Function FOURIER            \LIBRARY\ANALYSIS\analysis.xla    Command Macro FTESTV             \LIBRARY\ANALYSIS\analysis.xla    Command Macro FVSCHEDULE         \LIBRARY\ANALYSIS\analysf.xla     Custom Function GCD                \LIBRARY\ANALYSIS\analysf.xla     Custom Function GESTEP             \LIBRARY\ANALYSIS\analysf.xla     Custom Function HEX2BIN            \LIBRARY\ANALYSIS\analysf.xla     Custom Function HEX2DEC            \LIBRARY\ANALYSIS\analysf.xla     Custom Function HEX2OCT            \LIBRARY\ANALYSIS\analysf.xla     Custom Function HISTOGRAM          \LIBRARY\ANALYSIS\analysis.xla    Command Macro IMABS              \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMAGINARY          \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMARGUMENT         \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMCONJUGATE        \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMCOS              \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMDIV              \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMEXP              \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMLN               \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMLOG10            \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMLOG2             \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMPOWER            \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMPRODUCT          \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMREAL             \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMSIN              \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMSQRT             \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMSUB              \LIBRARY\ANALYSIS\analysf.xla     Custom Function IMSUM              \LIBRARY\ANALYSIS\analysf.xla     Custom Function INTRATE            \LIBRARY\ANALYSIS\analysf.xla     Custom Function ISEVEN             \LIBRARY\ANALYSIS\analysf.xla     Custom Function ISODD              \LIBRARY\ANALYSIS\analysf.xla     Custom Function LCM                \LIBRARY\ANALYSIS\analysf.xla     Custom Function MCORREL            \LIBRARY\ANALYSIS\analysis.xla    Command Macro MCOVAR             \LIBRARY\ANALYSIS\analysis.xla    Command Macro MDURATION          \LIBRARY\ANALYSIS\analysf.xla     Custom Function MOVEAVG            \LIBRARY\ANALYSIS\analysis.xla    Command Macro MROUND             \LIBRARY\ANALYSIS\analysf.xla     Custom Function MULTINOMIAL        \LIBRARY\ANALYSIS\analysf.xla     Custom Function NETWORKDAYS        \LIBRARY\ANALYSIS\analysf.xla     Custom Function NOMINAL            \LIBRARY\ANALYSIS\analysf.xla     Custom Function OCT2BIN            \LIBRARY\ANALYSIS\analysf.xla     Custom Function OCT2DEC            \LIBRARY\ANALYSIS\analysf.xla     Custom Function OCT2HEX            \LIBRARY\ANALYSIS\analysf.xla     Custom Function ODDFPRICE          \LIBRARY\ANALYSIS\analysf.xla     Custom Function ODDFYIELD          \LIBRARY\ANALYSIS\analysf.xla     Custom Function ODDLPRICE          \LIBRARY\ANALYSIS\analysf.xla     Custom Function ODDLYIELD          \LIBRARY\ANALYSIS\analysf.xla     Custom Function OPEN.DIALOG        \LIBRARY\filefns.xla              Custom Function PRICE              \LIBRARY\ANALYSIS\analysf.xla     Custom Function PRICEDISC          \LIBRARY\ANALYSIS\analysf.xla     Custom Function PRICEMAT           \LIBRARY\ANALYSIS\analysf.xla     Custom Function PTTESTM            \LIBRARY\ANALYSIS\analysis.xla    Command Macro PTTESTV            \LIBRARY\ANALYSIS\analysis.xla    Command Macro QUOTIENT           \LIBRARY\ANALYSIS\analysf.xla     Custom Function RADIANS            \LIBRARY\addinfns.xla             Custom Function RANDBETWEEN        \LIBRARY\addinfns.xla             Custom Function RANDOM             \LIBRARY\ANALYSIS\analysis.xla    Command Macro RANKPERC           \LIBRARY\ANALYSIS\analysis.xla    Command Macro RECEIVED           \LIBRARY\ANALYSIS\analysf.xla     Custom Function REGRESS            \LIBRARY\ANALYSIS\analysis.xla    Command Macro REPORT.DEFINE      \LIBRARY\reports.xla              Command Macro REPORT.DELETE      \LIBRARY\reports.xla              Command Macro REPORT.GET         \LIBRARY\reports.xla              Command Macro REPORT.PRINT       \LIBRARY\reports.xla              Command Macro REPORT.PRINT? \LIBRARY\reports.xla             Command Macro RESTORE            \LIBRARY\debug.xla                Command Macro SAMPLE             \LIBRARY\ANALYSIS\analysis.xla    Command Macro SAVE.DIALOG        \LIBRARY\filefns.xla              Custom Function SCENARIO.ADD       \LIBRARY\scenario.xla             Command Macro SCENARIO.CELLS     \LIBRARY\scenario.xla             Command Macro SCENARIO.CELLS? \LIBRARY\scenario.xla            Command Macro SCENARIO.DELETE    \LIBRARY\scenario.xla             Command Macro SCENARIO.GET       \LIBRARY\scenario.xla             Command Macro SCENARIO.SHOW      \LIBRARY\scenario.xla             Command Macro SCENARIO.SHOW.NEXT \LIBRARY\scenario.xla             Command Macro SCENARIO.SUMMARY   \LIBRARY\scenario.xla             Command Macro SCENARIO.SUMMARY? \LIBRARY\scenario.xla            Command Macro SERIESSUM          \LIBRARY\ANALYSIS\analysf.xla     Custom Function SLIDE.COPY.ROW     \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.CUT.ROW      \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.DEFAULTS     \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.DEFAULTS? \LIBRARY\SLIDES\slides.xla       Command Macro SLIDE.DELETE.ROW   \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.EDIT         \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.EDIT? \LIBRARY\SLIDES\slides.xla       Command Macro SLIDE.GET          \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.PASTE        \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.PASTE.ROW    \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.PASTE? \LIBRARY\SLIDES\slides.xla       Command Macro SLIDE.SHOW         \LIBRARY\SLIDES\slides.xla        Command Macro SLIDE.SHOW? \LIBRARY\SLIDES\slides.xla       Command Macro SOLVER.ADD         \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.CHANGE      \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.DELETE      \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.FINISH      \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.FINISH? \LIBRARY\SOLVER\solver.xla       Command Macro SOLVER.GET         \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.LOAD        \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.OK          \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.OK? \LIBRARY\SOLVER\solver.xla       Command Macro SOLVER.OPTIONS     \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.RESET       \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.SAVE        \LIBRARY\SOLVER\solver.xla        Command Macro SOLVER.SOLVE       \LIBRARY\SOLVER\solver.xla        Command Macro SQRTPI             \LIBRARY\ANALYSIS\analysf.xla     Custom Function TBILLEQ            \LIBRARY\ANALYSIS\analysf.xla     Custom Function TBILLPRICE         \LIBRARY\ANALYSIS\analysf.xla     Custom Function TBILLYIELD         \LIBRARY\ANALYSIS\analysf.xla     Custom Function TOGGLE.ALL         \LIBRARY\whatif.xla               Command Macro TOGGLE.ONE         \LIBRARY\whatif.xla               Command Macro TTESTM             \LIBRARY\ANALYSIS\analysis.xla    Command Macro VIEW.DEFINE        \LIBRARY\views.xla                Command Macro VIEW.DELETE        \LIBRARY\views.xla                Command Macro VIEW.GET           \LIBRARY\views.xla                Command Macro VIEW.SHOW          \LIBRARY\views.xla                Command Macro VIEW.SHOW? \LIBRARY\views.xla               Command Macro WORKDAY            \LIBRARY\ANALYSIS\analysf.xla     Custom Function XIRR               \LIBRARY\ANALYSIS\analysf.xla     Custom Function XNPV               \LIBRARY\ANALYSIS\analysf.xla     Custom Function YEARFRAC           \LIBRARY\ANALYSIS\analysf.xla     Custom Function YIELD              \LIBRARY\ANALYSIS\analysf.xla     Custom Function YIELDDISC          \LIBRARY\ANALYSIS\analysf.xla     Custom Function YIELDMAT           \LIBRARY\ANALYSIS\analysf.xla     Custom Function ZTESTM             \LIBRARY\ANALYSIS\analysis.xla    Command Macro