Connecting cells and flipping the data between two values

[Frankwest]

I'm trying to make a row of true and false values which will effect each other and i'm not sure how to go about it.

so for example if i had a row like this:

True

False

False

True

True

False

<tbody>
</tbody>

and i changed the first cell (True) to False the result should be this:

False

True

True

False

False

True

<tbody>
</tbody>

I'm fairly new to excel so this will be a big help, thank you.

sorry if the explanation and grammar is slightly off i have had next to no sleep.

 

[gaz_chops]

If your data starts in cell A1, then try

In cell B1 Enter =A1=FALSE
In cell C1 Enter =B1
In cell D1 Enter =C1=FALSE
In cell E1 Enter =D1
In cell F1 Enter =E1=FALSE

 

[Toadstool]

Is this what you want?

Results

	A	B	C	D	E	F
1	TRUE	FALSE	FALSE	TRUE	TRUE	FALSE
2	FALSE	TRUE	TRUE	FALSE	FALSE	TRUE

<tbody>
</tbody>

​

Formulae

	A	B	C	D	E	F
1	TRUE	=NOT(A1)	=NOT(A1)	=A1	=A1	=NOT(A1)
2	FALSE	=NOT(A2)	=NOT(A2)	=A2	=A2	=NOT(A2)

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>