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

	A​	B​
1​	FALSE​	A1:A4: {= {0;1;0;1} >0}
2​	TRUE​
3​	FALSE​
4​	TRUE​