Returns the account type for the chosen segment value. This function is only applicable for the natural account segment and will return the value Asset, Liability etc.

ParameterDescription
Segment ValueThe segment value.
SegmentThe segment number.
BookOptionally enter a set of books / ledger id to bind the formula to a specific set of books / ledger. If this parameter is omitted, the set of books currently selected in the Set of Books dropdown list will be used.
Independent ValueFor dependent segments, enter the independent value that the segment value relates to.

Example =GLW_Account_Type(“1000”,3)

Attachments: