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"," ")
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"," ")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks