 BitLsbOperation ( OPC ; OP1 ; OP2 )

bitwise logical operation     Average rating: 4.1 (48 votes) Log in to vote Erich Schmidt - Show more from this author
Sample input:
BitLsbOperation( 14 ; 3 ; 2)
BitLsbOperation( 8 ; 17 ; 12)
Sample output:
1
0

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Function value is the result of any logical operation between the LSBs (least significant Bits) of the integer values OP1 and OP2. The parameter OPC determines what operation is performed.

Parameters:
OP1, OP2 any integer values
OPC can be any integer number from 0 to 15
OPC=0 is true, if OP1 AND NOT OP1 is true (never)
OPC=1 is true, if NOT (OP1 OR OP2) is true
OPC=2 is true, if NOT OP1 AND OP2 is true
OPC=3 is true, if NOT OP1 is true
OPC=4 is true, if OP1 AND NOT OP2 is true
OPC=5 is true, if NOT OP2 is true
OPC=6 is true, if OP1 XOR OP2 is true (exclusive or)
OPC=7 is true, if NOT (OP1 AND OP2) is true
OPC=8 is true, if OP1 AND OP2 is true (conjunction)
OPC=9 is true, if NOT ( OP1 XOR OP2) is true (equivalence)
OPC=10 is true, if OP2 is true
OPC=11 is true, if NOT OP1 OR OP2 is true
OPC=12 is true, if OP1 is true
OPC=13 is true, if OP1 OR NOT OP2 is true
OPC=14 is true, if OP1 OR OP2 is true (disjunction)
OPC=15 is true, if OP1 OR NOT OP1 is true (always)