title: Is there an excel formula that will round negative numbers up? i.e. round(-2.5) = -2
body: <p>Microsoft Office Excel 2010 rounds 2.5 to 3. It also rounds -2.5 to -3. </p>
  
  <p>I'm trying to use Excel validate my data against a system that rounds -2.5 to -2. Different systems seem to use different tie breaking rules (i.e. I learned the hard way that Oracle use opposite rules).</p>
  
  <p>Is there an Excel formula that will round -2.5 to -2? Creativity is also acceptable (i.e. simple macro).</p>
  
  <p>It should also round:</p>
  
  <pre><code>-2.7 -&gt; -3
  -2.2 -&gt; -2
  </code></pre>
  
  <p>This rounds in the opposite direction that I'm looking for:</p>
  
  <pre><code>=ROUND(-2.5,0)
  </code></pre>
  
  <p>EDIT: I previously said that one type of rounding is more correct than another. After more research, I didn't one more popular than another. But I did find the default <a href="https://math.stackexchange.com/questions/3448/rules-for-rounding-positive-and-negative-numbers">IEEE rounding rule</a>, which is strangely, break ties by rounding to the nearest half number. I'm not looking for this method though :)</p>