Thread: How to get a conditional argument to check all cells in a array?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Just 4 Today Just 4 Today is offline
external usenet poster
  
Posts: 1
Default How to get a conditional argument to check all cells in a array?
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?
Reply With QuoteReply With Quote