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: RATE / spec for omitted parameters


Hi Eike

Briefly looked at RATE this morning. My starting point was:
RATE( Number Nper ; [Number Payment] ; Number Pv ; 
      [ Number Fv = 0 ] ; [ Number PayType = 0 ] 
      [ ; Number Guess = 0.1 ] )

and I planned to add further [] brackets to cope with omitted 
semicolons.

However it looks as if we need to consider exactly what is to be 
legal. Here's a review,  of {Fv; PayType; Guess}, ignoring any 
omitted Payment:

all parameters:
RATE( NPER; Payment; Pv; Fv; PayType; Guess)

missing one parameter:
RATE( NPER; Payment; Pv;   ; PayType; Guess)
RATE( NPER; Payment; Pv; Fv;        ; Guess)
RATE( NPER; Payment; Pv; Fv; PayType       )
RATE( NPER; Payment; Pv; Fv; PayType;      )  Error in Calc; OK 
in Excel

missing two parameters:
RATE( NPER; Payment; Pv;   ;        ; Guess)
RATE( NPER; Payment; Pv;   ; PayType       )
RATE( NPER; Payment; Pv;   ; PayType;      )  Error in Calc; OK 
in Excel
RATE( NPER; Payment; Pv; Fv;        ;      )  Error in Calc; OK 
in Excel
RATE( NPER; Payment; Pv; Fv;               )  Error in Calc; OK 
in Excel
RATE( NPER; Payment; Pv; Fv                )

missing three parameters:
RATE( NPER; Payment; Pv;   ;        ;      )  Error in Calc; OK 
in Excel
RATE( NPER; Payment; Pv;   ;               )  Error in Calc; OK 
in Excel
RATE( NPER; Payment; Pv;                   )  Error in Calc; OK 
in Excel
RATE( NPER; Payment; Pv                    )

I don't have Gnumeric, etc. to hand....

David



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