title: Excel IF Formula varififying one cell has data and another cell has specific value
body: <p>I have an excel spreadsheet that contains data for projects that we are working on. I need to output "Assign Me" in cell C3 if A3 contains any data and B3 does not contain 5 different team members names. See image below: I need the Status to read Assign Me ONLY if A1 = also contains data. In row 4 below A4 doesn't contain data... I need the formula to check for the specific names AS WELL as for text in column A. And if Column A doesn't have text it should output blank.</p>
  
  <p>Column C3 formula: 
  <code>=IF(B3="Jon","",IF(B4="Sally","",IF(B3="Connie","",IF(B3="Edgar","",IF(B3="Tony","","Assign Me")))))</code></p>
  
  <p>This formula doesn't validate there being text in Column A. </p>
  
  <pre><code>       A         B         C    
  1     3/21      Jon             
  2     3/21      Oscar   Assigned
  3               Oscar   Assigned
  </code></pre>
  
  <p>Here is what I need.</p>
  
  <p>I need the following expressed in an excel formula If A3 is blank AND IF B3 does not contain  Jon, Sally, Connie, Edgar, or Tony then display "Assign Me" in C3. If not, leave C3 blank.</p>
  
  <p>What do I need to add to make it work as intended?</p>