How can I do AND operation on two binary numbers in MS Excel?
Zuke,
Not a complete solution yet, but the ArrayFormula "{=F11+F12}" returns
10102002, so with a couple of SUBSTITUTEs you get the answer.
There probably a better way !
NickHK
"Zuke" wrote in message
...
I want to do AND say to the following:
00101001
AND to
10001001
and should get the following answer:
00001001
What function should I use in MS Excel to get this?
|