title: Excel "ISBLANK" function With "IF" function
body: <p>I have multiple Excel workbooks in which there are many columns. There will be a column in English and a column in Spanish.  What I am trying to do is compare the two columns to see if the Spanish column does indeed have translated text from English. That's easy enough:</p>
  
  <pre><code>IF(A2=C2, "NOT TRANSLATED", "TRANSLATED")
  </code></pre>
  
  <p>However, there are hundreds of cells that simply do not have values in both the English and Spanish columns. So the formula I used above will say "Yes, these are technically the same value even though they're null, so no translation has been done". This is causing it to seem like there are far too many "NOT TRANSLATED" values than there actually are. This is what I tried:</p>
  
  <pre><code>IF(A2=C2, "NOT TRANSLATED", "TRANSLATED", IF(ISBLANK(A2)=TRUE, "NULL VALUE", "CHECK VALUE"))
  </code></pre>
  
  <p>That gives me an error though.</p>
  
  <p>I am thinking that I need to have a function that first checks to see if the cell has a value to begin with. If it does, then the formula should proceed to check to see if the two cells have identical values or not. If either cell does not have a value, then it should return "NULL VALUE". Any ideas?</p>