New Function GLMULTI from Scott's Add-ins image

New Function GLMULTI from Scott's Add-ins

This powerful new function allows the user to specify non-consecutive GL accounts.

News
onMonday 1 May 2023

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)

Where:

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!

Sign up to our newsletter - don't miss out on all the good stuff.

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.

Connect with us

  • Facebook logo
  • Twitter logo
  • LinkedIn logo
  • YouTube logo