OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: ODFF: DISC function


DISC
* noting again that the formula given needs to divide by YEARFRAC 
not multiply
* I've verified that Excel and Calc both seem to use YEARFRAC 
internally to calculate DISC, therefore where there are problems 
in Excel/Calc with YEARFRAC (already noted by David Wheeler), 
they transfer to DISC. In addition of course, when Calc returns a 
value of YEARFRAC different to Excel, DISC will also be different 
(example 1Jan08 to 2Jan08, basis 1).


David



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]