A1="" returns TRUE.
A2="" returns TRUE.
A3="" returns TRUE.
Even (A1="")*(A2="") and AND(A1="";A2="";A3="") return TRUE.
But A1:A3="" returns a #VALUE error. How do you test all the cells in an array/range against a single value?
I can’t be the first person in spreadsheet history to want to check an array/range against another value? There must be some way to do it.