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 |
"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 |
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 |
All times are GMT +1. The time now is 08:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com