Bit wise and function.
 

Can any body help me with a function which does bit wise and for binary
numbers.

Also is there any function which converts binary numbers with 16 digits to
Decimal.

Regards,

Satish Salankimatt.

Bit wise and function.
 

Although BIN2DEC can only deal with up to 10 bits, if you've got a 16 bit
number you can split it and use
=256*BIN2DEC(LEFT(A33,8))+BIN2DEC(RIGHT(A33,8))
--
David Biddulph

"Satish Salankimatt." <Satish wrote
in message ...
....
Also is there any function which converts binary numbers with 16 digits to
Decimal.
....

Bit wise and function.
 

If A1 and B1 hold the two numbers, the following formula will
calculate the numeric value of their bitwise AND:

=SUMPRODUCT(MOD(INT(A1/2^(ROW(1:16)-1)),2)*MOD(INT(B1/2^(ROW(1:16)-1)),
2)*2^(ROW(1:16)-1))

HTH
Kostis Vezerides

On Mar 21, 10:14 am, Satish Salankimatt. <Satish
wrote:
Can any body help me with a function which does bit wise and for binary
numbers.

Also is there any function which converts binary numbers with 16 digits to
Decimal.

Regards,

Satish Salankimatt.