Bit wise and function.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

in message ....
Also is there any function which converts binary numbers with 16 digits to
Decimal.
Click to expand...
....
 
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
 
Back
Top