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.

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.
....

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.