Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Boolean masks
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 |
#2
|
|||
|
|||
"Howard" wrote in message ... 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 |
#3
|
|||
|
|||
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 "Howard" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to list unique values | Excel Worksheet Functions | |||
boolean find criteria in Excel | Excel Discussion (Misc queries) |