Formula operators.
About operators.Operators specify the type of calculation that is performed on the terms of a formula. Each operator can combine a specific number of formula terms (called the operands of the operator). This number ranges from one, in the case of the "not" operator, to three, in the case of the "if" operator.
NumericBase includes seven different types of operators: arithmetic, comparison, concatenation, logical, member access, the "if" operator, and the "alt" operator
Arithmetic operators.
These operators perform basic mathematical operations such as addition, subtraction, or multiplication. They produce output value of numeric type.
These operators expect input value of numeric type, if the input values are not a numeric value then they are converted automatically.
The different arithmetic operators are listed in the following table:

Comparison operators
These operators perform basic comparison operations such as less than, equal, etc. They get 2 input values and produce one output value of boolean type.
The different comparison operators are listed in the following table:

Concatenation operator.
This operator concatenates two or more strings to produce a single string. It produces output value of text type.
This operators expects input values of text type, if the input values are not a text value then they are converted automatically.
This operator is described in the following table.

Logical operators.
These operators perform basic logical operations. They expect boolean values as the values of their operands and produces one boolean value as output. If the input values are not of boolean type, then they are converted automatically.
The different comparison operators are listed in the following table:

Access operators.
Consist of the dot operator(.),the index operator([]), and the "at" operator (@). Some examples for usage:
 Table.a
 a[3]
 expanses@quorter1
The "alt" operator
The "alt" operator let you specify several alternative formulas in a cell. See the circular dependency page for more details.
The "if" operator.
Used to perform conditional calculations. More information about this operator in the if operator section.
Copyright © 2003  2024 by symbol click. Contact info