title: Multiple IF functions in Excel: how to override on IF statement if another IF is true.
body: <p>I have two columns of data. </p>
  
  <pre><code>1 FALSE
  2 FALSE
  3 FALSE
  4 FALSE
  5 TRUE
  6 TRUE
  7 TRUE
  8 TRUE
  
  44.0099
  16.043
  30.0696
  44.0972
  58.1234
  58.1234
  72.1503
  65.5401
  </code></pre>
  
  <p>I want to write an IF statement with multiple nested IFs such that: </p>
  
  <pre><code>IF(8=TRUE,72.1503, IF(8 &amp; 7 = True, 65.4501,.... IF( 8:1 = True, 44.0099)
  </code></pre>
  
  <p>However, when more cells are 'True', I want this to override the preceding IF statement. </p>
  
  <p>For example, say if 8 and 7 are True, I want the result of this to override the result if just 8 is True and so on.... if 8 and 7 and 6 are True, I want this to override the result of that if just 8 and 7 are True. </p>
  
  <p>Hope this makes sense? </p>