Search Msdn

Basis Argument for Financial Functions

This article describes the Basis argument and how it is evaluated in Microsoft Excel financial functions.

XL2000: Basis Argument for Financial Functions

This article describes the Basis argument and how it is evaluated in Microsoft Excel financial functions.

XL98: Basis Argument for Financial Functions

This article describes the Basis argument and how it is evaluated in Microsoft Excel 98 Macintosh Edition financial functions.

XL97: Financial Functions Return #NUM! If Dates After Year 2078

If you use a financial function from the Analysis ToolPak in Microsoft Excel 97, and you pass a date greater than 12/31/2078 to the function, the function may return the #NUM ...

XL: Adjusting the Period of Financial Functions

The compounded period used by Microsoft Excel in calculating financial functions can be altered by changing the number of periods over which the function is calculated. For example ...

XL2000: Some Financial Functions May Return Incorrect Results with ...

In Microsoft Excel, certain financial functions may return an incorrect value. Excel may calculate an incorrect value when the following conditions are true: You are using one of ...

XL: Examples of Interest Calculations Outside the United States

Microsoft financial functions presume customary financial practices in the United States. Other countries have different laws about quoting and computing interest. This article ...

XL2000: Algorithms Used in the ATP Functions

For detailed information about the algorithms or financial methods used to create the Microsoft Excel financial functions, refer to the following books:

Algorithms Used in the ATP Functions

For detailed information about the algorithms or financial methods used to create the Microsoft Excel financial functions, refer to the following books:

XL2000: Overview and History of Excel 2000 Updates

247795 (http://support.microsoft.com/kb/247795/EN-US/ ) XL2000: Some Financial Functions May Return Incorrect ...

XL98: Using NPV() or Solver to Find Guess for IRR()

For more information about the IRR Function, click the Office Assistant, type financial functions, click Search, and then click to view "IRR."

Npv Method [Excel 2007 Developer Reference]

For information about annuities and financial functions, see PV. NPV is also related to the IRR function (internal rate of return). IRR is the rate for which NPV equals zero: NPV ...

XL97: How to Use the EFFECT and NOMINAL Functions to Calculate Loan or ...

Financial institutions may calculate interest based on ... and illustrates the importance of knowing the financial environment in which you are using the worksheet functions.

Ispmt Method [Excel 2007 Developer Reference]

... by negative numbers; the cash you receive, such as dividend checks and other deposits, is represented by positive numbers. For additional information about financial functions, see ...

OFFAUTMN.exe discusses Office 97 and 2000 Automation and provides ...

You don't need to write your own calculation engine to provide the multitude of mathematical, financial, and engineering functions that Excel provides; Instead, you can automate ...

How to set up and use the RTD function in Excel

... create a workbook that includes data that is updated in real time, for example, financial ... For example, in the previous scenario, the user might be provided with two functions ...

XL2000: ODDFYIELD Returns #NUM with Online Help Example

This behavior also applies to the following worksheet functions: ODDFPRICE; ODDLPRICE; ODDLYIELD; For more information about the resources used to derive financial, statistical, and ...

Pv Method [Excel 2007 Developer Reference]

In annuity functions, cash you pay out, such as a deposit to savings, is represented by a ... Microsoft Excel solves for one financial argument in terms of the others.

Chapter 4: Explore Range Objects

Contrast this to when you use the same functions from the global group—or as members of ... uses a data type (currency) that can handle the large-scale precision needed in financial ...