Arithmetic & logical operators

Top Previous Next

FormCalc SST's spreadsheet has the following built-in operators.

In this topic:

Arithmetic Operators

Logical Operators

Arithmetic Operators

Arithmetic operators let you perform basic arithmetic operations.

Symbol	Operand Type	Example	Explanation
+	Two arguments	=B1+5	Adds the first argument’s value to the value of the second argument.
-	Two arguments	=A5-B1	Subtracts the second argument’s value from the value of the first one.
*	Two arguments	=A2*A3	Multiplies the first argument’s value by the value of the second argument.
/	Two arguments	=A15/7.33	Divides the first argument’s value by the value of the second argument.
^	Two arguments	=B1^A2	Raises the first argument’s value to the power determined by the second argument’s value.

Logical Operators

Logical operators perform comparisons and return a logical value (TRUE or FALSE) as a result.

Symbol	Operand Type	Example	Explanation
=	Two arguments of logical types	=A1=A2	Equality. Returns TRUE if the first argument is equal to the second one. Otherwise, returns FALSE.
<>	Two arguments of logical types	=A1<>B2	Inequality or "not equal". Returns TRUE if values within the list are not equal. Otherwise, returns FALSE.
<	Two arguments of logical types	=A2<B4	Less than. Returns TRUE if the first argument is less than the second one. Otherwise, returns FALSE.
>	Two arguments of logical types	=A12>100	Greater than. Returns TRUE if the first argument is greater than the second one. Otherwise, returns FALSE.
<=	Two arguments of logical types	=A2<=C4	Less than or equal to. Returns TRUE if the first argument is less than or equal to the second one. Otherwise, returns FALSE.
>=	Two arguments of logical types	=A2>=2.45	Greater than or equal to. Returns TRUE if the first argument is greater than or equal to the second one. Otherwise, returns FALSE.