How to match bits to a certain value

[Guest]

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.

 

[Biff]

What are you looking for here? Do you want this to be part of some VB code
or do you have the data in worksheet cells and need a formula?

So, any solution is better than NO solution, right? How about an IF formula?

Binary *TEXT* string in A1.

A1 = 00001011

=IF(MID(A2,1,1)="1","R","")&IF(MID(A2,2,1)="1","O","")&IF(MID(A2,3,1)="1","Y","")&IF(MID(A2,4,1)="1","G","")&IF(MID(A2,5,1)="1","B","")&IF(MID(A2,6,1)="1","I","")&IF(MID(A2,7,1)="1","V","")&IF(MID(A2,8,1)="1","P","")

Returns: BVP

Biff