title: IF Logic for Multiple arguments in Excel
body: <p>I'm hoping someone can please assist me with this problem. In the following cells, I have the following values:</p>
  
  <pre><code>P8 = 9 
  Q8 = 7 
  R8 = 5 
  S8 = 4 
  T8 = 2
  </code></pre>
  
  <p>Essentially, I want a formula that looks back across 4 cells and identifies if the trend has declined for 1, 2, 3 or 4 cells with an output in cell U8. U am currently trying the following formula which isn't working:</p>
  
  <pre><code>`=if(((T8&lt;S8,S8&lt;R8,R8&lt;Q8,Q8&lt;P8),"4"),((T8&lt;S8,S8&lt;R8,R8&lt;Q8),"3"),((T8&lt;S8,S8&lt;R8),"2"),(T8&lt;S8,"1"))`
  </code></pre>