We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calc: How do you check an array of cells against a single value? [closed]

asked 2012-04-09 06:28:02 +0200

Paul451 gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 23:04:13.536225

1 Answer

Sort by » oldest newest most voted

answered 2012-04-09 07:01:20 +0200

Pedro gravatar image

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.

edit flag offensive delete link more

Question Tools


Asked: 2012-04-09 06:28:02 +0200

Seen: 1,388 times

Last updated: Apr 09 '12