Overview of Operators

Operators

Description

Example

Outcome

+

(Plus or string concat)

Plus two numbers for addition; or concat both elements(numbers and text).

[number1/Text1]+[number2/Text2]

E1. 1+3;

E2. 1+abc

E3. a+xy

E1. 4

E2: 1abc

E3. axy

-

(Minus)

Minus number(s) for subtraction.

[number1]-[number2]

3-1

2

*

(Multiply)

Multiple numbers for multiplication.

[number1]*[number2]

3*4

12

/

(Divide)

Divide by sign for division

[number1]/[number2]

15/3

5

%
(Modulo)

Return the remainder(modulus) after a division of one number by another.

[number1]%[number2]

8%5

3

(

(Open paren)

Open parenthesis.

It must consist of open parenthesis and close parenthesis.

3*(5+3)

24

)

(Close paren)

Close parenthesis.

It must consist of open parenthesis and close parenthesis.

3*(5+3)

24

And

Returns TRUE if all of its arguments are TRUE.

Mostly it's used between expressions.

E1: 7 > 0 and 5 > 3;

E2: variable 1==ABC and variable 2>500

E1: "Yes" or "Ture";

E2: "No" or "False"

[Assumed that variable 1 is "ABD", variable 2 is "800".]

Or

Returns TRUE if any argument is TRUE.

Mostly it's used between expressions.

E1: 7 > 0 or 5 > 8;

E2: variable 1==ABC or variable 2>500

E1: "Yes" or "Ture";

E2: "Yes" or "True"

[Assumed that variable 1 is "ABD", variable 2 is "800".]

==

(Equal)

Equal sign, indicating the same value.

Mostly it's used between functions.

iif(variable1==A, GOOD,BAD)

"GOOD"

[Assumed that variable1 is "A"]

!=

(Not equal)

Not equal sign, indicating not have the indicated value.

Mostly it's used between functions.

iif(variable1!=A, GOOD,BAD)

"BAD"

[Assumed that variable1 is "A"]

>

(Greater than or equal)

Used to compare expressions, indicating numeric values higher than the comparison.

iif(variable1 >100 , GOOD,BAD)

"BAD"

[Assumed that variable1 is "90"]

>=

(Greater than)

Used to compare expressions, indicating numeric values the same or higher than the comparison.

<

(Less than)

Used to compare expressions, indicating numeric values less than the comparison.

iif(variable1 <100 , Need improve,GOOD)

"Need improve"

[Assumed that variable1 is "90"]

<=

(Less than or equal)

Used to compare expressions, indicating numeric values the same or less than the comparison.