Boolean masks

[Guest]

I want to use boolean masking eg 10011 AND 01011 should return 00011 but I
just keep getting TRUE or FALSE from the AND operator. Is there something
I'm missing or can EXCEL not do this?

Thanks for any help

 

[Fredrik Wahlgren]

I want to use boolean masking eg 10011 AND 01011 should return 00011 but I
just keep getting TRUE or FALSE from the AND operator. Is there something
I'm missing or can EXCEL not do this?

Thanks for any help

Not directly. You need to make a User Defined Function. Here's some VB6 code
that you can use.
http://www.devx.com/vb2themax/Tip/19306

/Fredrik

 

[Chip Pearson]

Howard,

VBA supports bitwise AND (and ORs). For example,

Dim X As Integer
Dim Y As Integer
Dim Z As Integer
X = 19 '10011
Y = 11 '01011
Z = X And Y ' Z = 3
Debug.Print Z


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com