Archive

Archive for April 14th, 2012

Syteline Financial Excel Add-in: How to reference unit codes with mixed cell references and hard-coded values

April 14th, 2012 No comments

When specifying unit codes in the Excel formulas, to use both a cell reference in addition to hard-coded values, you need to append the two with ‘&’.  For example, if unit code 1 value is in cell $A$1, and you don’t want to include * for each of the three remaining unit codes, the Unit Code parameter would look like: $A$1 & ",*,*,*".  In a SLGL formula, that would look like:

=SLGL(account, period, year, $A$1 & ",*,*,*")

Categories: Development Tags: