ACCRUED INTEREST (ACCRINT) Bug
thanks. That is my interpretation as well.
"Fred Smith" wrote:
I agree it's returning the wrong value. It looks like it's ignoring the
final parameter -- it's assuming True regardless.
Regards,
Fred.
"Keith" wrote in message
...
I used the Following Data:
Copy Paste into Cell A1:
Data Description
11/30/2008 Issue date
5/31/2009 First interest date
6/26/2009 Settlement date
1.25% Coupon rate
1,000,000 Par value
2 Frequency is semiannual (see above)
1 Actual/Actual
0 CALC METHOD
Formula Description (Result)
=ACCRINT(A2,A3,A4,A5,A6,A7,A8,A9)
$7,142.86 MS answer
End Copy Paste section
The Real Answer is 887.98
The help file States "A value of FALSE (0) returns the accrued interest
from
first_interest to settlement."
That is not the result of this formula.
|