Converting 1,0 array to true,false array

[makihussain]

I need to convert 1/0 array to True/False array

Example converting {0;1;0;1} to {False;True;False;True}

Thanks

 

[Tetra201]

Try this:

=IF({0;1;0;1},TRUE,FALSE)

 

[makihussain]

Tetra201,

Many thanks. I appreciate your swift response.

 

[Jonmo1]

Perhaps

=NOT(1-{0;1;0;1})

 

[shg]

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

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]

FALSE​

[/td][td]A1:A4: {= {0;1;0;1} >0}[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

TRUE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

FALSE​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

TRUE​

[/td][td][/td][/tr]
[/table]