title: How to round up with excel VBA round()?
body: <p>I have the following data:</p>
  
  <pre><code>cell(1,1) = 2878.75
  cell(1,2) = $31.10
  cell(2,1) = $89,529.13
  </code></pre>
  
  <p>However, when I tried to use <code>round(cells(1,1).value*cells(1,2).value),2)</code>, the result does not match <code>cell(2,1)</code>. I figured it has to do with the rounding issue, but I'm just wondering if it is possible to get <code>round()</code> to act normally. That is, for <code>value &gt; 0.5</code>, round up. And for <code>value &lt; 0.5</code>, round down?</p>