title: How to use ISBLANK in nested if-statement?
body: <p>I need help in converting the following if-statements in Excel formula.</p>
  
  <ul>
  <li>if A1 and B1 are blank, then C1 is "",</li>
  <li>if A1 is not blank and B1 is blank, then C1 is "New",</li>
  <li>if A1 and B1 are not blank, then C1 is "Existing".</li>
  </ul>
  
  <p>Here is what I have could have tried but didn't bother to:</p>
  
  <pre><code>IF(AND(ISBLANK(A1),ISBLANK(B1)),"",
  IF(AND(NOT(ISBLANK(A1)),ISBLANK(B1)),"NEW",
  IF(AND(NOT(ISBLANK(A1)),(NOT(ISBLANK(‌​B1)),"EXISTING",""))
  </code></pre>
  
  <p>but it gives me an error.</p>