Some functions have a variable number of arguments with some (typically the last) arguments being optional. These are displayed in this reference with the word Optional in brackets "[Optional]" before the argument in the table of arguments. For example, consider the payment function (PMT) which has five arguments with the last two being optional. In Spread, you can make any of the following calls:

    PMT(rate,nper,pv,fv,type)

    PMT(rate,nper,pv,fv)

    PMT(rate,nper,pv,fv,)

    PMT(rate,nper,pv,,type)

    PMT(rate,nper,pv,,)

    PMT(rate,nper,pv)

The optional arguments may be omitted. Any missing optional argument is handled with the default value being passed. For example

    FIXED(1234.5678,,FALSE)

evaluates the same as

    FIXED(1234.5678,2,FALSE)

since the default value for the number of decimal places is 2.

See more about Missing Arguments.

Return to Functions in a Formula.

Return to the Formula Overview.