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.

 

[Luthius]

Ok. The first step is solved.
Now the problem/challenge is use Boole Algebra to get a result without use IF formula as I said before.

 

[Scott Huish]

What were saying is that Excel doesn't work that way. Is there a point to this?
You could write a UDF but that would probably contain Ifs as well.

 

[xenou]

Ok. The first step is solved.
Now the problem/challenge is use Boole Algebra to get a result without use IF formula as I said before.

I don't think that helps us. You don't want an array of true and false. You want an array of numbers that are not zero and false. This would be the set of values you want to average, with false being ignored by the average formula.

 

[Scott Huish]

Here's your answer without an IF:

=SUMPRODUCT(--({4,5,6,7,8,9,10}>=2),--({4,5,6,7,8,9,10}<=8),{4,5,6,7,8,9,10})/MAX(1,SUMPRODUCT(--({4,5,6,7,8,9,10}>=2),--({4,5,6,7,8,9,10}<=8)))