Microsoft KB Archive/247795

= XL2000: Some Financial Functions May Return Incorrect Results with February 29, 2000 =

Article ID: 247795

Article Last Modified on 5/12/2007

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q247795



SYMPTOMS
In Microsoft Excel, certain financial functions may return an incorrect value.



CAUSE
Excel may calculate an incorrect value when the following conditions are true:  You are using one of the following worksheet functions provided by the Analysis ToolPak add-in:

 ACCRINT COUPDAYBS COUPDAYS COUPDAYSNC COUPPCD COUPNCD</li> DURATION</li> MDURATION</li> ODDFPRICE</li> ODDFYIELD</li> PRICE</li> YIELD</li></ul>

-and-

</li> The bond's maturity, settlement, or first interest payment takes place on February 29, 2000.</li></ul>

<div class="resolution_section">

RESOLUTION
A Microsoft Excel 2000 Analysis ToolPak Update that resolves this issue is available for download from the following Microsoft Web site:

http://office.microsoft.com/downloads/2000/Atpy2k.aspx

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

Additional query words: XL2000 atp y2k year2000 year 2000

Keywords: kbdownload kbbug kbofficeupdate kbpending KB247795

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.