title: Round function in Excel, worksheet function vs VBA
body: <p>I had an application for returning closest matches to certain values in a large  cluster of values( as in my earlier <a href="https://stackoverflow.com/questions/220966/lookup-data-in-excel">question</a>)   and I chose a VBA solution. While in the course of using the said application, I observed that the results for the value of 0.5 were not correct. I had been using the VBA Round function which I found to be returning 0 for 0.5 rounded to integer whereas the worksheet round function returns 1. Strangely, the VBA round function returns 2 for 1.5. I had to substitute the worksheet function in place of the VBA one.</p>
  
  <p>Am I missing something?</p>