Array to meet conditions
I have a row of formula results that will either have a value of "OK" or the
result of a vlookup. In the next column, I am trying to write a formula that
will say "OK" if ALL of the other columns also say OK so I can sort out the
rows that are not OK. (Imagine columns B-Q have the OK or vlookup results
and column R is trying to summarize those results). So in column R I have
tried:
{=IF((B37:Q37)="OK","OK","ERROR")}
The problem here is that I get a result of OK if ANY of cells in the array
say OK. I only want a result of OK if ALL the cells in the array say OK.
What am I missing? (Or is there a completely different better way to do
this?)
Thank you!
Erin
|