title: Increment constant in Excel Formula
body: <p>Suppose, in Excel, I have a formula <code>=$C$8+1</code>, what must I add to the 1 such that when I drag, it becomes <code>$C$8+2</code>? </p>
  
  <p>Can this be done?</p>
  
  <p>Below is my actual formula.. I wish to increment 1 to 2 such that it becomes =2 </p>
  
  <pre><code>IF((NOW()-$C8)=1,"1","0")
  </code></pre>