title: multiple conditions in excel showing points
body: <p>I'm trying to make multiple functions where it shows a certain point if..</p>
  
  <p>multiple conditions in excel showing points</p>
  
  <pre><code>if A1 is bigger than 500 shows 0
  if A1 is smaller than 500 but greater than 200 then shows 0.3
  if A1 is smaller than 200 but greater than 100 then shows 0.6
  if A1 is smaller than 100 then shows 1
  </code></pre>
  
  <p>Thank you</p>