Re: testing coupnum

["Andreas J. Guelzow" <aguelzow taliesin ca>]

Thanks,

Gnumeric and XL appear to give the same (inconsistent) answers. THe code 
for coupnum in XL appears correct even if their coupncd
 has probelms. :-)

Andreas

Dave Reed wrote:

> > Given this data in the top left cells (A1:D2)
> >
> > 29-Nov-2000     30-May-2001     4     0
> > 30-Nov-2000     30-May-2001     4     0
> >
> > could soembody with XL on Windows, tell me the values of:
> >
> > coupnum(A1,B1,C1,D1)
> > coupnum(A2,B2,C2,D2)
> > coupncd(A1,B1,C1,D1)
> > coupncd(A2,B2,C2,D2)
> >
> > Thanks
> >
> > Andreas
>
> Office 97 Excel:
> 3
> 2
> 36950
> 36950
>
> Dave



--
Prof. Dr. Andreas J. Guelzow
http://www.math.concordia.ab.ca/aguelzow