How to convert an array of zeros into an arry of true and false?

[Luthius]

How to convert an array of zeros into an array of true and false without use IF formula?

FROM
{0;1;0;1;0;1}

TO
{FALSE;TRUE;FALSE;TRUE;FALSE;TRUE}

Ps. The array of false and true, within a formula.

 

[Domenic]

Is this what you mean?

{0;1;0;1;0;1}=1

 

[Luthius]

Almost there...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Well, look this<o></o>
<o></o>

STEP 01<o:p></o:p>
=AVERAGE(({4,5,6,7,8,9,10}>=2)*({4,5,6,7,8,9,10}<=8)*({4,5,6,7,8,9,10}))

<o></o>
<o></o>

<o:p></o:p>
RESULTS<o:p></o:p>
<o:p></o:p>
=AVERAGE({1,1,1,1,1,0,0}*{4,5,6,7,8,9,10})<o:p></o:p>
<o:p></o:p>
Resulting in 4,285714286.<o:p></o:p>
<o:p></o:p>

<o></o>
<o></o>
This results is because the zeros inside the formula.<o></o>
But What I'm trying to do is get the result without use 'IF' formula.<o></o>
Using IF Formula
<o></o>
<o></o>

Step 1<o:p></o:p>
AVERAGE(IF({4,5,6,7,8,9,10}>=2,IF({4,5,6,7,8,9,10}<=8,{4,5,6,7,8,9,10}))) 

<o></o>
<o></o>

<o:p></o:p>
RESULTS<o:p></o:p>
<o:p></o:p>
=AVERAGE(IF({TRUE,TRUE,TRUE,TRUE,TRUE,TRUE,TRUE},{4,5,6,7,8,FALSE,FALSE})<o:p></o:p>
<o:p></o:p>
STEP 2<o:p></o:p>
AVERAGE({4,5,6,7,8,FALSE,FALSE})<o:p></o:p>
<o:p></o:p>
Resulting in 6.

With FALSE inside, the formula ignore it, and give me the real average.

 

[shg]

Why not use IF?

=AVERAGE(IF(({4,5,6,7,8,9,10}>=2) * ({4,5,6,7,8,9,10}<=8), {4,5,6,7,8,9,10}))

 

[Luthius]

No I dont want to use IF formula, I want to solve it using Boolean Algebra.

 

[xenou]

Excel treats true as 1 and false as 0 in mathematical operations - which is what happens here since you multiply the true/false results. I'm not aware of anyway around that (except applying IF to the results - so back to where you started).

 

[Luthius]

Yes excel treats this way false and true.
Thats the reason I came here.
To put a new challenge for us. Solve it without use IF formula.

 

[Gerald Higgins]

It really might help to explain why you want to do this.

Like xenou said, 0 and False are in many respects the same as far as Excel is concerned, so why even bother to differentiate ?

 

[xenou]

FROM
{0;1;0;1;0;1}

TO
{FALSE;TRUE;FALSE;TRUE;FALSE;TRUE}

Try:
NOT(NOT({0;1;0;1;0;1}))

But this isn't really what you want - you want 0's converted to FALSE and other numbers to remain what they are (not to become TRUE's).

 

[shg]

Or {0;1;0;1;0;1}=1