Thread: How can I do AND operation on two binary numbers in MS Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default How can I do AND operation on two binary numbers in MS Excel?
All you need to do is to put the zeros and ones in separate cells. Then the
AND function will work:

=--AND(A1,A2)
--
Gary's Student


"Zuke" wrote:

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?



Reply With QuoteReply With Quote