simonwait
asked on
Breaking down a decimal into bit parts
I need to find some way, ideally through a formula to solve the following problem. I have a bunch of numbers (bit numbers for some inputs so 2,4,8,16,32,64,128,256,512 ,1024. My data usually only produces a definitive number ie 64 however it sometimes comes out with 66 (64+2), 322 (2+64+256) etc. Is there a way of breaking these numbers into their constitant parts? It feels like something previously done but i just cant find the information.
Thanks in advance
Thanks in advance
Simple UDF:
Function BitwiseAnd(var1, var2)
BitwiseAnd = var1 And var2
End Function
ASKER
I think I may have not given all the information. the bit numbers relate to input names which are referenced using vlookup, ie 2 = a, 4 = b, 16 = c, d = 32, e = 64 etc.... I then need to produce a string based on the multiple amounts. ie 66 would produce "a e".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I meant to award to rorya but seem to have done something wrong
ASKER