 <p>You might find this formula helpful, it will check for a null value in either column</p> <p><code>{=IF(OR(A1:B1=""),"Null Value",IF(A1=B1,"Not Translated","Translated"))}</code></p> <p>Leave out the curly braces and enter the function using <kbd>Ctrl</kbd>+<kbd>Shift</kbd>+<kbd>Enter</kbd></p> <p>You can drag that down for the following results</p> <p><code> a a Not Translated b c Translated d Null Value e Null Value Null Value f f Not Translated </code></p>