Put an X in a cell if there is Text in a Range of Cells. Leave blank if not.

The Cell count say Star, Certificate, Rookie or be blank.
If the K10:S10 says either Star, Certificate or Rookie, I want an x in cell AC10, if nothing, leave it blank.

Here is what I have so far
=IF(K10="STAR",)OR(O10="Certificate","X"," ")

if "nothing" in your condition requirement means "blank" in all K10:S10, that will be easy

AC10=IF(COUNTBLANK(K10:S10)=9,"","X")

Originally Posted by pschultz614

The Cell count say Star, Certificate, Rookie or be blank.
If the K10:S10 says either Star, Certificate or Rookie, I want an x in cell AC10, if nothing, leave it blank.

Here is what I have so far
=IF(K10="STAR",)OR(O10="Certificate","X"," ")

or
AC10=if(COUNTA(K10:S10)>0,"X","")

Originally Posted by FDibbins

I have no rweal idea what you are trying to do, but see if this is what you are looking for...

=IF(sum(countif($K10:$S10,{"STAR","Certificate","Rookie"}))>0,"X"," ")