ACCRINT( )

[chengj]

when i use the function ACCRINT(),I meet a problem.
ACCRINT("39507","39691","39569",0.1,1000,2,2)=17.222222222
BUT:
ACCRINT("39507","39691","39569",0.1,1000,4,2)=16.666666667
39507---"2008-2-29"
39691---"2008-8-31"
39569---"2008-5-1"
As you see, when "Frequency"=4 the result is smaller.
who can tell me why?

Thank you very much!

 

[Vasant Nanavati]

Did you not like my answer to your earlier, identical post?

 

[Guest]

thank you !
but I think your answer isn't correct!
Thank you all the same

 

[Vasant Nanavati]

No doubt you are right. However, it is better to continue the discussion in
the same thread rather than reposting the same question in a new thread. I
do see that you have another, probably better answer in the original thread.