Public Comment: ODFF: FV function

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Major
    • ODF 1.2
    • Affects Version/s: None
    • Component/s: OpenFormula
    • None
    • Hide

      Change Syntax from
      FV( Number Rate ; Number Nper ; Number Payment [ ; Number Pv = 0 [ ; Number PayType = 0 ] ] )
      to
      FV( Number Rate ; Number Nper ; Number Payment [ ; [ Number Pv = 0 ] [ ; Number PayType = 0 ] ] )

      The same for PV, PMT and NPER with parameter names exchanged accordingly.

      Show
      Change Syntax from FV( Number Rate ; Number Nper ; Number Payment [ ; Number Pv = 0 [ ; Number PayType = 0 ] ] ) to FV( Number Rate ; Number Nper ; Number Payment [ ; [ Number Pv = 0 ] [ ; Number PayType = 0 ] ] ) The same for PV, PMT and NPER with parameter names exchanged accordingly.

      Copied from office-comment list

      Original author: "David King" <[email protected]>
      Original date: 13 Aug 2008 21:58:25 -0000
      Original URL: http://lists.oasis-open.org/archives/office-comment/200808/msg00037.html

      • PMT can be omitted (default = 0) in Calc and Excel, if Pv is given.
      • [] optional parameter brackets are wrong - Pv can be omitted while PayType is present.

      [ed:] See Eike's comment below from 2010-01-14

            Assignee:
            Eike Rathke (Inactive)
            Reporter:
            Robert Weir (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: