The following Power Tip comes to us from Scott’s Add-in user and Excel guru, David Clements. David provides insights on how to leverage the =SCOTT.GLMULTI function and Excel. Thank you, David! The new =SCOTT.GLMULTI function allows multiple account inputs. While this method of selecting individual cells or ranges may be appealing to some, it is …
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 …
Shoot us an email and we
will do our best to
respond quickly.
Copyright © 2023 Scotts-add-ins