Operators
Technical Articles > Using Formulas in Table Cells
An operator applies a specific operation to adjacent formula elements. There a three different groups of operators TX Text Control supports: arithmetic, comparison and text concatenation operators. Arithmetic operators perform mathematical operations where the result is a numerical value. While applying comparison operators results in a logical value, text concatenations are joining strings.
| Arithmetic Operator |
|
Example |
| + (Addition)
| |
The formula 8+6 returns 14. |
| - (Substraction)
| |
The formula 14-6 returns 8. |
| * (Multiplication)
| |
The formula 4*3 returns 12. |
| / (Division)
| |
The formula 17/2 returns 8.5. |
| % (Percent)
| |
The formula 290% returns 2.9. |
| ^ (Exponentiation)
| |
The formula 3^2 returns 9. |
| Comparison Operator |
|
Example |
| = (Equal to)
| |
The formula 2=2 returns TRUE. |
| > (Greater Than)
| |
The formula 4>6 returns FALSE. |
| < (Less Than)
| |
The formula 4<6 returns TRUE. |
| >= (Greater than or equal to)
| |
The formula 6>=4 returns TRUE. |
| <= (Less than or equal to)
| |
The formula 26<=4 returns FALSE. |
| <> (Not equal to)
| |
The formula 2<>2 returns FALSE. |
| Text Concatenation Operator |
|
Example |
| & (Concatenation)
| |
The formula "TX"&"Spell" returns TXSpell. |
<< Constants | >> Functions