BitOperation( BitNr ; RC ; OPC ; OP1 ; OP2 )
Rate this function: Average rating: 4.2 (19 votes) Discuss this Custom Function
Erich Schmidt, SchmidtITBeratung
http://www.schmidtitberatung.de
bitwise logical operation
Sample Input:
BitOperation( 0 ; 0 ; 6 ; 145 ; 345)
BitOperation( 0 ; 0 ; 14 ; 5 ; 12)
BitOperation( 0 ; 0 ; 8 ; 5 ; 12) 

Sample Output:

Description:
Function value is the result of any bitwise logical operation between the binary representation of the integer values OP1 and OP2. Only the 16 least significant bits are processed.
The operation is given by OPC, which can be any integer number from 0 to 15. OPC determines what operation is performed.
Requires other Custom Functions:
BitLsbOperation()
Parameters:
BitNr, RC these parameters must be set to 0 by the caller. Otherwise it leads to faulty results.
OP1; OP2 any integer values (numbers greater than 65,535 are possible, but
useless)
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 OP1 OR NOT 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 ist true, if OP1 OR NOT OP1 is true (always)
Some simple examples
Set bit 2 and bit 5 in OP1. All other bits leave unchanged.
BitOperation( 0 ; 0 ; 14 ; OP1 ; 2^2+2^5)
Toggle bit 0 , bit 3 and bit 12 in OP1. All other bits leave unchanged.
BitOperation( 0 ; 0 ; 6 ; OP1 ; 2^0+2^3+2^12)
Clear bits 8 and 9 in OP1. All other leave unchanged.
BitOperation( 0 ; 0 ; 4 ; OP1 ; 2^8+2^9)
Check, if one of bit 3 or 5 in OP1 is set.
Itâ€˜s true, if the expression BitOperation( 0 ; 0 ; 8 ; OP1 ; 2^3+2^5) is true (not 0).
Note: these functions are not guaranteed
or supported by BrianDunning.com. Please contact the individual
developer with any questions or problems.
This is my Custom Function and I want to
edit it
Discuss:There are no comments yet. Be the first to post a comment about this Custom Function! Please try to keep it brief & to the point. Anyone can post:

Newest Custom Functions:
1. 
RandomKey ( characters ; size ) 

(Thu, Jul 21, 10:11am) 
2. 
CountWorkingDays ( DateStart; DateEnd ) 

(Mon, Jul 18, 11:37am) 
3. 
CheckDigit_GTIN_13 ( SeedNumber ) 

(Wed, Jul 13, 4:33am) 
4. 
evaluateAsNeeded ( value ) 

(Tue, Jul 12, 9:47pm) 
5. 
DotwCWYtoDate ( DOTW ; CW ; Y ) 

(Fri, Jul 08, 9:40pm) 
6. 
DDStoDDM ( LATorLNG) 

(Thu, Jul 07, 11:37am) 
7. 
Phone Format 

(Wed, Jul 06, 7:02pm) 
8. 
CreateRandomPassword ( PasswordLength ; Parameter ; String ) 

(Wed, Jul 06, 8:37am) 

