Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I don't think this is very hard, but I'm not sure how to approach it.
Basically I have an 8 bit binary code that represents a decimal value between 0 and 255, and each of the 8 bits represents a different color. By either using the decimal or binary number, I need to output the corresponding color. Say the 8 bits are equivalent to ROYGBIVP (8 colors). ie bit 7=Red, bit 6= Orange, bit 5=yellow, etc., down to bit 0=purple. So, if I have 00001011 (decimal 8+2+1=11), then I would output BVP or, if I have 11010000 (decimal 128+64+16= 128), then I would output ROG It doesn't matter if you use the binary (to match bit by bit) or decimal (using remainder function, even, odd, ,<, etc., or anything else I don't know about). Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |