title: How to calculate growth with a positive and negative number?
body: <p>I am trying to calculate percentage growth in excel with a positive and negative number.</p>
  
  <pre><code>This Year's value: 2434
  Last Year's value: -2
  </code></pre>
  
  <p><strong>formula I'm using is:</strong></p>
  
  <pre><code>(This_Year - Last_Year) / Last_Year
  
  =(2434 - -2) / -2
  </code></pre>
  
  <p>The problem is I get a negative result.  Can an approximate growth number be calculated and if so how?</p>