Spread.NET 15 Formula Reference
Formula Overview / Functions in a Formula / Optional Arguments
In This Topic
    Optional Arguments
    In This Topic

    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:







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


    evaluates the same as


    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.