View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default How to match bits to a certain value

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.