title: Comparing in data in excel
body: <p>Anybody knows how to compare data in two columns in excel?
  This is the conditions, if <code>column R = Column S</code> result should be <code>PASSED</code>, else if <code>column R - Column S &gt; 1</code>, result is <code>FAILED</code> and if the two column's difference is <code>0.01</code> only, it should return <code>Rounding Off Error</code>.</p>
  
  <p>I've already tried this one but is not working well :</p>
  
  <pre><code>=IF(ROUND(R5,2)=ROUND(S5,2),"PASS",IF(ROUND(R5,2)&gt;ROUND(S5,2),"Rounding Off Error",
  IF(ROUND(S5,2) &gt; ROUND(R5,2), "Rounding Off Error","FAIL")))
  </code></pre>
  
  <p>In this conditions,  <code>-100.71 - 0.00</code> and <code>100 - 0.00</code> it should return <code>FAIL</code>. The conditions I've done only works when this condition is met <code>-100.71 - 0.00</code>, it returns <code>FAILED</code>. But in this one <code>100 - 0.00</code>, it returns <code>Rounding Off Error</code>. Any help?</p>
  
  <p>Thanks in advance!</p>