This powerful new function allows the user to specify non-consecutive GL accounts.
New Function GLMULTI from Scott's Add-ins
We have added a new function =SCOTT.GLMULTI . This powerful new function allows the user to specify non-consecutive GL accounts. The user can also specify a range in the formula. The syntax is:
=SCOTT.GLMULTI (OrgID, StartDate, EndDate, [Accounts], [Accounts],…..)
Here is an example:
=SCOTT.GLMULTI (A1, A2, A3, B5, B8, B10:B15, B20)
A1 = Scotts Org ID
A2 = StartDate
A3 = EndDate
B5 = account code
B8 = account code
B10:B15 = a range of accounts
B20 = account code
Two accounts are summed up, a range of accounts added, then another account.
A few things to note:
GLMULTI will accept account descriptions in place of account codes.
If an inactive account is included a range, its balance will be included in the sum.
Invalid account codes will be ignored, and will not result in #VALUE.
Please enjoy using GLMULTI to create financial art!
Latest news, events, and updates on all things app related, plus useful advice on app advisory - so you know you are ahead of the game.