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

From BetaArchive Wiki

Article ID: 925797

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Excel 2003



SYMPTOMS

You use the YIELD function in a formula in Microsoft Office Excel 2003. The YIELD function results in an unexpectedly large value if the following conditions are true:

  • The security's settlement date is the 30th or the 31st of the month.
  • The security's maturity date is the 30th or the 31st of the same month.

Note The YIELD function returns the yield on a security that pays periodic interest.

CAUSE

This problem may occur if the Basis parameter is set to 4 in the YIELD function.

RESOLUTION

This problem was first fixed in a hotfix that is now contained in a service pack. If you installed the latest Office 2003 service pack, you do not have to install the hotfix.

Service pack information

This problem is corrected in Office 2003 Service Pack 3. To resolve this problem, obtain the latest service pack for Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

870924 How to obtain the latest service pack for Office 2003


Hotfix information

To resolve this problem, you must apply this hotfix. Additionally, you must apply the Excel 2003 post-Service Pack 2 hotfix package (Analys32.xll) that is dated November 7, 2005. For more information about the Excel 2003 post-Service Pack 2 hotfix package (Analys32.xll) that is dated November 7, 2005, click the following article number to view the article in the Microsoft Knowledge Base:

904826 Description of the Excel 2003 post-Service Pack 2 hotfix package (Analys32.xll): November 7, 2005


How to obtain the hotfix

This issue is fixed in the Excel 2003 post-Service Pack 2 Hotfix Package that is dated September 25, 2006. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

925796 Description of the Excel 2003 post-Service Pack 2 hotfix package: September 25, 2006


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.This problem was first corrected in Office 2003 Service Pack 3.

MORE INFORMATION

The Basis parameter is the type of day count basis to use with the YIELD function.

The following table lists the valid values for the Basis parameter.

Basis Day count basis
0 or omitted US (NASD) 30/360
1 Actual/actual
2 Actual/360
3 Actual/365
4 European 30/360

For more information about the YIELD function, click Microsoft Excel Help on the Help menu, type YIELD in the Search for box in the Assistance pane, and then click Start searching to view the topic.


Additional query words: excel2003 excel2k3 excel11 xl2003 xl2k3 xl11

Keywords: kbbug kbfix kbqfe kbformula kbpubtypekc kbfunctions kbexpertiseinter kbhotfixserver kboffice2003sp3fix KB925797