How to get a conditional argument to check all cells in a array?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Excel 2003.
I would like to check all cells in an array for a number. In a cell not in
the array I have the formula {=If(A1:A9=1," ",1)}. Currently if there is a 1
in A1 I get a blank. If there is a 1 in A2 to A9 I get a 1 not a blank. Why?
 
I don't think you need an array formula

=IF(COUNTIF(A1:A9,1)>0,"",1)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create an array of separate cells 1
Index from TM 8
If data present, then display graph. 2
Adding up with array formula 2
Storing an array in a cell 9
Ignore blanks in multiplication formula 4
Average more than 30 numeric arguments 15
MATCH to ignore blank cells in array 3

Back
Top