I'm sure I'm missing something simple here, but I can't see what.
In cells A1:A3 I have values of 1; in cells B1:B3 I have the array formula =A1=1 (filled down). In cell B4 I have the array formula =(B1:B3)=TRUE [or =(B1:B3=TRUE) - they both seem to work the same].
If all 3 values in column A = 1, cell B4 returns TRUE; if I change cell A1 to 0, A1 and B4 change to FALSE; however, if I reset A1 to 1 and change either A2 or A3 to 0, B4 stays TRUE.
Any ideas as to where I have gone wrong?
Many thanks,
Batman.