Hi Luke (and/or others) - Happy to elaborate, although was trying to keep it

simple and not scare off everyone with all the gory details. The function is

intended to check if the data in the four cells is a) all 1's, b) all 0's, or

c) a mix. If either a) or b) are true the function should produce that

single digit. If the function is false then it returns a concatenated string

of all the data. Here goes:

{=IF(MIN(N(INDIRECT("Rater" & ROW(1:4) & "!B"&$B$3)))=MAX(N(INDIRECT("Rater"

& ROW(1:4) & "!B"&$B$3))),MAX(N(INDIRECT("Rater" & ROW(1:4) &

"!B"&$B$3))),CONCATENATE(INDIRECT("Rater1!B"&$B$3),"

",INDIRECT("Rater2!B"&$B$3)," ",INDIRECT("Rater3!B"&$B$3),"

",INDIRECT("Rater4!B"&$B$3)))}

I used (with help from someone on this board) the "MIN=MAX" construct to

efficiently cover conditions a or b (when all four cells match, MIN=MAX) and

return the correct output. It seems to work fine - including the false

condition - except when one of the cells is blank. for instance, three 1's

and a blank produce the following:

1 1 1

which is all four cells concatenated together. So it is treating the blank

cell as 0 or as you suspect an error that gets concerted to 0, thus MIN<>MAX.

I want it to consider three 1's and a blank as all 1's, and return a 1.

Hope that helps!