Arithmetic & logical operators

Top  Previous  Next

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

In this topic:

 

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.