=IF(COUNTIF(Sheet1!L14:Q14,5)+COUNTIF(Sheet1!L14:Q 14,"false")=6,"x","")

--
Gary''s Student - gsnu200777


"MichaelZ" wrote:

I have a row of cells (i.e., L14:Q14) on Worksheet 1 whose possible values
are either: 0, 1, 3, 5, "false". On Worksheet 2, for a particular cell, I'd
like to return a value of "X" if the values in row 14 of Worksheet 1 are
either a "5" or "false" (note, they have to all be either a 5 or false),
otherwise, if they are not all either a "5" or "false" then I'd like to
return a blank, " " on Worksheet 2.

Thanks in advance for any advice.

Michael