title: Mod Returning Different Outputs When Using Formula
body: <p>I am getting conflicting results.</p>
  
  <p>With the formula:</p>
  
  <blockquote>
    <p><code>=MOD(1,1)</code></p>
  </blockquote>
  
  <p>I get <code>0</code> as one would expect.</p>
  
  <p>But if I come to that <code>1</code> by formula:</p>
  
  <blockquote>
    <p><code>=MOD((1.2-1)/0.2,1)</code></p>
  </blockquote>
  
  <p>I get <code>1</code>.</p>
  
  <p>Even if I split out the formula into its parts:</p>
  
  <blockquote>
    <p><code>=(1.2-1)/0.2</code></p>
  </blockquote>
  
  <p>and</p>
  
  <blockquote>
    <p><code>=MOD(B5,1)</code></p>
  </blockquote>
  
  <p>I get <code>1</code></p>
  
  <p>So the question is, "Why the difference?"</p>
  
  <p><a href="https://i.stack.imgur.com/XoFE8.png" rel="noreferrer"><img src="https://i.stack.imgur.com/XoFE8.png" alt="enter image description here"></a></p>