Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. .... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summing function in pivot table in column wise ?? | Excel Worksheet Functions | |||
row wise query | New Users to Excel | |||
row wise query | Excel Discussion (Misc queries) | |||
Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
Delete row wise duplicates & colomun wise simultaneously excel | Excel Worksheet Functions |