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/106464

From BetaArchive Wiki


Excel: Add-in Files and Their Associated Functions

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

REFERENCES

"User's Guide 2," version 4.0, pages 195-202


KBCategory: kbusage

KBSubcategory:

Additional reference words: 4.00 4.00a



Last reviewed: September 12, 1996
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.