title: If 1 or 2 cells are blank then
body: <p>I'm trying to write a simple formula to check whether either 1 or both cells are blank and, if so, leave the resulting cell blank. I want the resulting cell to only display a calculation if both cells are filled in.</p>
  
  <p>I've got this do far though it doesn't work as I wanted: <code>=IF(OR(C4&lt;&gt;"",B4&lt;&gt;""),A4-C4,"")</code></p>
  
  <p>b4 has a date and c4 has a numeric value (4). the formulate is in d4. I want to check if b4 or c4 are blank and, if so, leave d4 blank too, else take c4 from a4 (14 as of now).</p>