NumericBase - 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:

Arithmetic operator	Number of operands	Arithmetic function	Example
+ (plus sign)	2	Addition	5+3
- (minus sign)	2	Subtraction	9-3
- (minus sign)	1	Negation	-7
* (asterisk)	2	Multiplication	2*9
/ (forward slash)	2	Division	3/5

Table: The arithmetic operators.

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:

Comparison operator	Meaning	Example
= (equal sign)	Equal to	4=4
> (greater than sign)	Greater than	product>200
< (less than sign)	Less than	34 < 45
>= (greater than or equal to sign)	Greater than or equal to	45>=454
<= (less than or equal to sign)	Less than or equal to	554<=545
<> (not equal to sign)	Not equal to	5<>7

Table: Comparison operators.

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.

Operator	Meaning	Example
& (ampersand)	Connects, or concatenates, two values to produce one continuous text value	"key" & "board" produced "keyboard"

Table: The concatenation operator.

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:

Logical operator	Number of operands	meanings	Example
and	2	True if both input values are true	4>3 and amount<3
or	2	True if one of the input value if true	5>6 or 4<5
not	1	Reverses the value of its input value.	not 4>5

Table: The logical operators.

Access operators.
Consist of the dot operator(.),the index operator([]), and the "at" operator (@). Some examples for usage:

Table.a
a[3]
expanses@quorter1

More information about these operators in the More about referring to other cells page

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.

(back) (Next - The if operator)