Operators
Syntax:
^ Not * / \ Mod + - & < <= > >= = <> Is
And Or Xor Eqv Imp
Description:
These operators are available for numbers n1 and n2 or strings s1 and s2.
If any value in an expression is Null then
the expression's value is Null. The order of
operator evaluation is controlled by operator precedence.
Operator
Description
- n1 Negate
n1.
n1 ^ n2 Raise n1 to the
power of n2.
n1 * n2 Multiply n1 by n2.
n1 / n2 Divide n1 by n2.
n1 \ n2 Divide the integer value of n1
by the integer value of n2.
n1 Mod
n2 Remainder of the integer value of n1
after dividing by the integer value of n2.
n1 + n2 Add n1 to n2.
s1 + s2 Concatenate s1 with
s2.
n1 - n2 Difference of n1
and n2.
s1 &
s2 Concatenate s1
with s2.
n1 <
n2 Return True if
n1 is less than n2.
n1 <=
n2 Return True if
n1 is less than or equal to n2.
n1 >
n2 Return True if
n1 is greater than n2.
n1 >=
n2 Return True if
n1 is greater than or equal to n2.
n1 = n2 Return True if n1 is equal to n2.
n1 <>
n2 Return True if
n1 is not equal to n2.
s1 <
s2 Return True if
s1 is less than s2.
s1 <=
s2 Return True if
s1 is less than or equal to s2.
s1 >
s2 Return True if
s1 is greater than s2.
s1 >=
s2 Return True if
s1 is greater than or equal to s2.
s1 = s2 Return True if s1 is equal to s2.
s1 <>
s2 Return True if
s1 is not equal to s2.
Not n1
Bitwise invert the integer value of n1. Only
Not True is False.
n1 And
n2 Bitwise and the integer value of n1
with the integer value n2.
n1 Or n2 Bitwise or the integer value of n1
with the integer value n2.
n1 Xor
n2 Bitwise exclusive-or the integer value of
n1 with the integer value n2.
n1 Eqv
n2 Bitwise equivalence the integer value of
n1 with the integer value n2
(same as Not (n1 Xor n2)).
n1 Imp
n2 Bitwise implicate the integer value of n1 with the integer value n2
(same as (Not n1) Or n2).
Example:
Sub Main
N1 = 10
N2 = 3
S1$ = "asdfg"
S2$ = "hjkl"
Debug.Print -N1 '-10
Debug.Print N1 ^ N2 ' 1000
Debug.Print Not N1 '-11
Debug.Print N1 * N2 ' 30
Debug.Print N1 / N2 ' 3.3333333333333
Debug.Print N1 \ N2 ' 3
Debug.Print N1 Mod N2 ' 1
Debug.Print N1 + N2 ' 13
Debug.Print S1$ + S2$ '"asdfghjkl"
Debug.Print N1 - N2 ' 7
Debug.Print N1 & N2 '"103"
Debug.Print N1 < N2 'False
Debug.Print N1 <= N2 'False
Debug.Print N1 > N2 'True
Debug.Print N1 >= N2 'True
Debug.Print N1 = N2 'False
Debug.Print N1 <> N2 'True
Debug.Print S1$ < S2$ 'True
Debug.Print S1$ <= S2$ 'True
Debug.Print S1$ > S2$ 'False
Debug.Print S1$ >= S2$ 'False
Debug.Print S1$ = S2$ 'False
Debug.Print S1$ <> S2$ 'True
Debug.Print N1 And N2 ' 2
Debug.Print N1 Or N2 ' 11
Debug.Print N1 Xor N2 ' 9
Debug.Print N1 Eqv N2 ' -10
Debug.Print N1 Imp N2 ' -9
End Sub
