Functions

Technical Articles > Using Formulas in Table Cells

TX Text Control provides predefined functions that perform specific calculations. The result of such calculations is always a number, logical value, string or an array of such values. The structure of a function begins with an upper case unique name followed by an opening parenthesis, all needed arguments separated by commas and ends with a closing parenthesis.

Valid arguments are numerical, logical, string and array values. These values can be directly set as constants, by the result of other function calculations or by a reference to another table cell.

Function Example
ABS(x) (Computes the absolute value of x) ABS(-7.765) results in 7.765.
PI() (Returns the value Pi) PI() results in 3.141592654.
POWER(x,y) (Computes x raised to the power y.) POWER(3,2.5) results in 15.5884573.
SUM(argument-list) (Returns the value 6) SUM(1,2,3) results in 6.
SUM(argument-list) (Returns the value 6) SUM({1;2;3}) results in 6.
SUM(argument-list) (Returns the value 6) SUM(A1:A3) results in 6 if the table cells A1, A2 and A3 provide the values 1, 2 and 3.

Lists with all supported formula functions can be found in the Supported Formula Functions section.