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
|