Operators

  • Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

The operators in table 1 can be used in formulas.

Table 1. Operators in ModelMuse Formulas

Operator

Meaning

Data Types

Result type

   


=

equals

real numbers, integers, Booleans, text

Boolean

<>

not equals

real numbers, integers, Booleans, text

Boolean

>

greater than

real numbers, integers, Booleans, text

Boolean

<

less than

real numbers, integers, Booleans, text

Boolean

>=

greater than or equals

real numbers, integers, Booleans, text

Boolean

<=

less than or equals

real numbers, integers, Booleans, text

Boolean

and

and

Booleans

Boolean

or

or

Booleans

Boolean

xor

exclusive or

Booleans

Boolean

not

not

Booleans

Boolean

mod

modulus (remainder)

integers

integer

div

integer division

integers

integer

^

raise a number to a power

real numbers, integers

real number

**

raise a number to a power

real numbers, integers

real number

*

multiplication

real numbers, integers

real number, integer

/

division

real numbers, integers

real number

+

addition or concatenation

real numbers, integers, text

real number, integer, text

-

subtraction

real numbers, integers

real number, integer