View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M John M John is offline
external usenet poster
 
Posts: 35
Default is there an "if for each"?

Hello,
I'm trying to do a 'check' formula. There is a column of data I want to
report on in a separate cell. In the case where all the data is the
same....say each cell in the column contains "1", is there an if-then formula
that I can use to get:

(in excel-ese:)

=if(each cell in column x = 1,good,bad)

Many thanks,
MJ