title: 99.9% returns false in If Statement
body: <p>I have an if statement and i cannot get a grip where I may have went wrong. everytime the results is 99.9% it is returning as &quot;False&quot;, whereas it should within range and should result to &quot;Awesome&quot;</p>
  <pre><code>99.6    Good!
  99.7    Great
  99.8    Cool!
  99.9    Super!
  100     Prima!!
  </code></pre>
  <p>there is definitely something wrong with my statement.</p>
  <pre><code>=if(K2=100%,$M$5,if(K2&gt;=99.9%,$M$4,if(K2&gt;=99.8%,$M$3,if(K2&gt;=99.7%,$M$2,if(K2&gt;=99.6%,$M$1)))))
  </code></pre>
  <p><a href="https://docs.google.com/spreadsheets/d/1TX49RPATclsWo7yUeJgUQ1x4CdBKAdniyxfX2DaWZLQ/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1TX49RPATclsWo7yUeJgUQ1x4CdBKAdniyxfX2DaWZLQ/edit?usp=sharing</a></p>
  <p><a href="https://i.stack.imgur.com/6uTJ0.png" rel="nofollow noreferrer">Added a photo here</a></p>