Difference between revisions of "Manuals/calci/BITAND"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''BITAND(n1,n2)'''</div><br/> | <div style="font-size:30px">'''BITAND(n1,n2)'''</div><br/> | ||
| − | *where <math>n1</math> and <math>n2</math> | + | *where <math>n1</math> and <math>n2</math> specify the numeric values on which the bitwise AND operation is performed. |
== Description == | == Description == | ||
| − | *BITAND() returns the result of | + | *BITAND() returns the result of bitwise AND operation performed on numeric values. |
*<math>n1</math> and <math>n2</math> must be in decimal form and greater or equal to '0'. | *<math>n1</math> and <math>n2</math> must be in decimal form and greater or equal to '0'. | ||
*The value of each bit position is counted only if both parameter's bits at that position are 1. | *The value of each bit position is counted only if both parameter's bits at that position are 1. | ||
| − | |||
| − | |||
*If either argument is a non-numeric value, BITAND returns the #VALUE! error value. | *If either argument is a non-numeric value, BITAND returns the #VALUE! error value. | ||
For Example, | For Example, | ||
| − | BITAND(1,6) = 0 | + | BITAND(1,6) = 0 (The binary representation of 1 is 1, and the binary representation of 6 is 110. Their bits do not match at any position. This is returned as 0. |
| − | BITAND( | + | BITAND(true, true) = '''1''' (Bit AND value of 'true' is '1'. Bits match the position, hence result is 1.) |
== Examples == | == Examples == | ||
| − | #=BITAND( | + | #=BITAND(3,5) = 1 |
| − | #=BITAND( | + | #=BITAND(17,-22) = 0 |
| − | #=BITAND( | + | #=BITAND(-9,-3) = -11 |
| − | #=BITAND(0.5 | + | #=BITAND(0.5,0.1) = 0 |
| − | |||
==Related Videos== | ==Related Videos== | ||
| − | {{#ev:youtube| | + | {{#ev:youtube|kNRNw0VMelo|280|center|AND}} |
Revision as of 05:35, 4 May 2017
BITAND(n1,n2)
- where and specify the numeric values on which the bitwise AND operation is performed.
and 
specify the numeric values on which the bitwise AND operation is performed.
Description
- BITAND() returns the result of bitwise AND operation performed on numeric values.
- and must be in decimal form and greater or equal to '0'.
- The value of each bit position is counted only if both parameter's bits at that position are 1.
- If either argument is a non-numeric value, BITAND returns the #VALUE! error value.
For Example,
BITAND(1,6) = 0 (The binary representation of 1 is 1, and the binary representation of 6 is 110. Their bits do not match at any position. This is returned as 0.
BITAND(true, true) = 1 (Bit AND value of 'true' is '1'. Bits match the position, hence result is 1.)
Examples
- =BITAND(3,5) = 1
- =BITAND(17,-22) = 0
- =BITAND(-9,-3) = -11
- =BITAND(0.5,0.1) = 0
Related Videos
See Also
References