BITAND function

BITAND function

This function lunched with Excel 2013 and it returns a bitwise “AND” of two numbers.

Example:- The binary number for 5 is 101 and for 9, it is 1001 and bits of these two number matches at rightmost postion only and hence the result should be 1.  BITAND function will return 1 in this case.

Explanation:-

Number -  Binary

5 -  101

9-  1001

As we only consider 1 for bit matching, we can clearly see that rightmost 1 is matching in above example.

 

Syntax:-

=BITAND( number1, number2)

 

where number1 and number 2 should be greater than or equal to Zero.

 

Note:- you’ll get #NUM error, if any of the 2 number are less than Zero and you’ll get #VALUE error if any non-numeric value entered in place of number 1 or number 2.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube