Syteline Financial Excel Add-in: How to reference unit codes with mixed cell references and hard-coded values
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
Recent Comments