title: Wrong value returned when using MIN Fuctions with nested IF - Excel
body: <p>I'm currently using the following function to calulcate the min value of any array based on several criteria and getting the correct answer:</p>
  
  <pre><code>=MIN(IF(Table5[G]="M"; IF(Table5[Level]=A3;Table5[Salary]);"-")) 
  </code></pre>
  
  <p>But I wanted to expand the function by adding an OR statement in the second IF statement:</p>
  
  <pre><code> =MIN(IF(Table5[G]="M"; IF(***OR(Table5[Level]=TEXT(A2;0);Table5[Level]=VALUE(A2))**;*Table5[Salary]);"-"))
  </code></pre>
  
  <p>For the range of A2:A16 I'm getting the exact same number ( Min value ) which is incorrect.</p>
  
  <p>Any Ideas?</p>