Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ACCRUED INTEREST (ACCRINT) Bug
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
ACCRUED INTEREST (ACCRINT) Bug
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vacation Accrued | Excel Discussion (Misc queries) | |||
What does the second parameter in ACCRINT do? | Excel Worksheet Functions | |||
ACCRINT formula yields incorrect result | Excel Worksheet Functions | |||
ACCRINT formula gives incorrect result | Excel Worksheet Functions | |||
Accrued Vacation | Excel Worksheet Functions |