First time here? Check out the FAQ!
asked 2012-04-09 06:28:02 +0200Paul451
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.
answered 2012-04-09 07:01:20 +0200Pedro
Your condition doesn't apply that way. If you are checking an array for a value, then you should expect an array, not a single value.
In your particular example if you type =A1:A3="" and then press Ctrl+Shift+Enter you will get 3 cells with TRUE.
If you are checking for values, you could use SUM(A1:A3)=0 as a condition instead.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-04-09 06:28:02 +0200
Seen: 217 times
Last updated: Apr 09 '12