Thread: how do I =if(any one of 20 specified cell=1," ",1)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default how do I =if(any one of 20 specified cell=1," ",1)
Try this:

=IF(COUNTIF(A1:A20,1),"",0)

Is that what you're looking for?

***********
Regards,
Ron


"gwbeck" wrote:

Excel formula help please. I want to check 20 cells within a spreadsheet for
a specific value. If at least one of the cells is equal to the specified
value return blank if none of the cells is equal to the specified value
return the specified value.
Reply With QuoteReply With Quote