Description
The ACCOUNTCLASS function returns the account class code of a General Ledger account.
Syntax
ACCOUNTCLASS(Connection, Account)
Parameters
The ACCOUNTCLASS function uses the following parameters (see our article on using Excel arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection, as specified in the Connection Manager |
Account | Required | The general ledger account for which the Account Class is to be displayed. |
Example
=ACCOUNTCLASS("Demo", "40020")
Description: Returns the account class of general ledger account 40200.
Result: SALES

If a non-existent account code is specified, the ACCOUNTCLASS function will display Account 'xxxxx' not found. ![]() or, if you have configured Velixo reports to return zero values under certain circumstances... ![]() ... your report will display Excel's #N/A error: ![]() |
Applies to
GL Module