Mathematical Operators: ( +, , *, /, ^, mod or %, >, <, <> or != ):
All mathematical expressions should be enclosed in parentheses when you are uncertain about how the precedence of calculations will be applied.
Operator Symbol: 
Description: 

+ 
Sums two variables. 
 
Finds the difference between two numbers. 
* 
Multiplies two numbers. result = ( expression1 * expression2 ) 
/ 
Divides two numbers. 
^ 
Raises expression1 to the power of an expression2. The result is always floating. result = ( expression1 ^ expression2 ) 
MOD or % 
MOD and % are modulus, or remainder operators. Result returned is a remainder value between 0 and the Absolute(value) of the number being divided. Sign of the resulting value is the same as the sign of the number being divided.
The arguments to the modulus operator may be floatingpoint numbers, so that 5.6 % 0.5 returns 0.1. Both operators will return the same result. Value returned by each is the remainder from the division. The left and right expressions can be floating or integer. The results will be float or int depending on the values used.
Examples: test.currentDate = ,20150101, 
> 
Greater than symbol used in a conditional reference test where a True or a False is needed. 1 > 2 = True, 2 > 1 = False 
< 
Less than symbol used in a conditional reference test where a True or a False is needed. 1 < 2 = True, 2 < 1 = False 
<> or != 
Both symbol pairs are used when the values on either side are Not True. 1 <> 2 = True, 2 <> 2 = False, 4 != 3 = True 
Logical Operators ( AND NOT OR ):
Operator Names: 
Description: 

AND 
Performs compound result of TRUE, if, and only if, all of its components are true. Result is always an Integer value.
TRUE will be returned when each variables are the same value FALSE will be returned when each value are NOT the same. 
NOT 
Performs logical negation of an expression. Result is always an Integer value.
Applying this operator to a variable will always returns a negated Integer value. ' Example: If Value is equal to 1, return will be: 
OR 
Performs a logical disjunction on two expressions. Result is always an Integer value.

Example  0: 

' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
Example  1: 

' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ If NOT condition1 THEN ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
Returns  1: 

condition1 = TRUE 1 
Example  2: 

' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ' ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
Returns  2: 

condition2 = FALSE 0 
Links: 

See Also: 

Edit Time: 9/25/2017 09:09:58 AM 
Topic ID#: 446 