Select Area:

User Forum  | Links | Example Scripts

Math and Concatenation

Arithmetic

Arithmetic can be used against any numeric data type.  The following symbols are used:

Concatenation

Concatenation is only used on string variables to combine them.  It does not perform any math.

Comparison

Comparison is used to compare the contents of two variables against each other.

Logic

Logic operations are used to evaluate one or more expressions and return logical values.

AND - logical conjunction
As a comparison operator: Returns True only if Expression1 and Expression2 are true.
Comparison Examples: 
                    boolReturn = Expression1 AND Expression2
                    If y = 15 AND x < 23 Then

As a bitwise operator:  Compares the bits in both numeric expressions and returns a value based on the following:

Essentially, the numeric values are evaluated at a binary level:
(147) 10010011
(58)  00111010
(18)  00010010

So, with this example, 147 AND 58 = 18
 

OR - logical disjunction
As a comparison operator: Returns True if Expression1 or Expression2 are true, and if Expression1 and Expression2 are true.
Comparison Examples: 
                    boolReturn = Expression1 OR Expression2
                    If y = 15 OR x < 23 Then

As a bitwise operator:  Compares the bits in both numeric expressions and returns a value based on the following:

Essentially, the numeric values are evaluated at a binary level:
(147) 10010011
(58)  00111010
(187) 10111011

So, with this example, 147 OR 58 = 187
 

NOT - logical negation
As a comparison operator: Negates the Boolean value of Expression1
 

As a bitwise operator:  Compares the bits in both numeric expressions and returns a value based on the following:

Essentially, the numeric values are evaluated at a binary level:
(58)  00111010
(197) 11000101

So, with this example, NOT 58 = 197
 

Eqv - logical equivalence
As a comparison operator: Returns True only if Expression1 equals Expression2
Comparison Examples: 
                    boolReturn = Expression1 Eqv Expression2
                    If y = 15 Eqv x < 23 Then

As a bitwise operator:  Compares the bits in both numeric expressions and returns a value based on the following:

Essentially, the numeric values are evaluated at a binary level:
(147) 10010011
(58)  00111010
(86)  01010110

So, with this example, 147 Eqv 58 = 86
 

Imp - logical implication
As a comparison operator: Returns based on table below
Comparison Examples: 
                    boolReturn = Expression1 Imp Expression2
                    If y = 15 Imp x < 23 Then

As a bitwise operator:  Compares the bits in both numeric expressions and returns a value based on the following:

Essentially, the numeric values are evaluated at a binary level:
(147) 10010011
(58)  00111010
(126) 01111110

So, with this example, 147 Imp 58 = 126
 

Xor - logical exclusion
As a comparison operator: Returns based on table below
Comparison Examples: 
                    boolReturn = Expression1 Xor Expression2
                    If y = 15 Xor x < 23 Then

As a bitwise operator:  Compares the bits in both numeric expressions and returns a value based on the following:

Essentially, the numeric values are evaluated at a binary level:
(147) 10010011
(58)  00111010
(169) 10101001

So, with this example, 147 Xor 58 = 160

Operator Precedence

When evaluating a calculation line, the line is processed in the following operator order, and within each operator class, in the order listed.  When evaluating a line, multiple identical operators are processed from left to right.

If you need to override any given precedence, you place the single calculation element within parenthesis. 

As an example of how operator precedence works, copy/paste this code snippet into notepad, save it and run it to see how the totals differ:  Change the uncommented line to see the different calculations.

Dim dblRetVal

dblRetVal = 1 + 1 / 5
'dblRetVal = (1 + 1) / 5

WScript.Echo dblRetVal

Mathematical Related Functions

There are several functions you can use to assist with calculations:

	Abs	Abs(Number)	Absolute Value
	Atn	Atn(Number)	Inverse trigonometric function of Tan
	Cos	Cos(Number)	Cosign
	Hex	Hex(Number)	Converts a number into Hexadecimal
	Log	Log(Number)	Logarithm
	Oct	Oct(Number)	Converts a number into Octal
	Sgn	Sgn(Number)	Sign
	Sin	Sin(Number)	Sine
	Tan	Tan(Number)	Tangent