Nest Boolean logic into CHOOSE function

Here is an example how to use BIN2DEC function to create criteria for CHOOSE function.
I find it usefull and didn't see it before so if it's already explained somewhere please take mine excuse.

In this example I take 3 option. That will give me 2^3 = 8 combinations.

Idea is to have 3 colors (RED, BLUE, YELLOW) and then choose them by YES/NO (Y/N) to create different pallete (not visually, just words).

So here is 8 combinations:

Please Login or Register  to view this content.

In following example I'll take BLUE and YELLOW while RED will remain N and Y/N options are in G column.

Please Login or Register  to view this content.

Idea is to convert each of them into 0/1 and join them together.

Formula:

Please Login or Register  to view this content.

So above table can be interpreted as:

Please Login or Register  to view this content.

Where those 8 combinations are actually binary numbers.
So if we convert BIN2DEC:

Formula:

Please Login or Register  to view this content.

Above values will be converted from 0 to 7.

Since index number of CHOOSE function is starting from 1 need to add +1 to get proper criteria:

Formula:

Please Login or Register  to view this content.

Value can be anything. Text, formula... And you need to define each of them.

For example:

Formula:

Please Login or Register  to view this content.

Of course, this can be achieved with other approach. This is just example how to use BIN2DEC function in some other way.