title: How do i make an if statement in excel return a blank?
body: <p>I swear I've done this 100 times but now for some reason it doesn't work. Here is the excel formula I have:</p>
  
  <p>=IF(AND(CurrentMonth>=9,CurrentYear>=2012),C5,"")</p>
  
  <p>CurrentMonth is 10 and CurrentYear is 2012</p>
  
  <p>C5 currently has no value, but is formatted as General. If I enter a ' into C5 the cell goes blank (result of the above If formula).</p>
  
  <p>If I set the CurrentMonth &lt; 9 or CurrentYear &lt; 2012 the result of the formula is blank. Problem seems to be with the C column...blank value in the C column seen as a zero entry.</p>
  
  <p>The resulting value is 0, but it should just be a blank/no value.
  I have formatted the cells to be General, the cells with the formulas as well as the cell containing CurrentMonth and Current Year.</p>
  
  <p>Thank you in advance for all help and recommendations. This community is the best.</p>