APBALANCE function

Returns balance of accounts payable at end of each month(s) from start month

Syntax

The APBALANCE function syntax has the following arguments

  • Total_expenses     Required.    Array.    Total amount of expenses related to this payable during each month(s)

  • AP_days     Required.    Number.    Number of days that your suppliers/vendors give you to pay

  • Month_number     Optional.    Number.    If you require this value for a specified month only (and not for several months), enter month for which this value is required. For example, enter 6 if you'd like this value for month 6 of this debt. Note: value will be returned for specified month only; default =1; must be integer >=1