title: Find what range a number belongs to
body: <p>Ive written a function to calculate what <strong>MARK</strong> a student gets, based on a scoring table.
  Why does my function work only for A mark?</p>
  
  <p>This what the excel sheet looks like</p>
  
  <pre><code>COLUMN:    A      B      C      
          Student  SCORE  MARK
      1    adsf     90     A
      2    asgfd    89     FALSE     
  
      3     A       90    100
      4     B       81    89
      5     C       71    80
      6     D       61    70
      7     E        56   60
      8     Fx       0    55
  </code></pre>
  
  <p>This is the function: </p>
  
  <pre><code>{=IF(B1&gt;=$B$3:$B$8,IF(B1&lt;=$C$3:$C$8,$A$3:$A$8))}
  </code></pre>
  
  <p>I'm using {} brackets for array functions. (CTRL SHIFT ENTER)</p>
  
  <p>Thank you</p>