title: Excel Min Function returns 0
body: <p>I have already checked the Excel Documentation... I am always getting 0</p>
  
  <p>this is my Excel Table<a href="https://i.stack.imgur.com/jUNRQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jUNRQ.png" alt="enter image description here"></a></p>
  
  <p>And this is my Code:</p>
  
  <pre><code>=MIN(IF(C7="X";C20);IF(D7="X";D20))
  </code></pre>
  
  <p>and If there is an "X" in Cell C7 and D7, I want to get the SMALLEST (MIN) value of Cell C20 or D20 and it works fine, BUT --> When I remove one "X" let say in Cell D7, I only get 0 back, becasue the Min Function always returns 0, if my IF Functions are not a digit / number, but when I remove my X, i always get False back from my IF() functions....</p>
  
  <p>So my question is, how could I ignore all If Return values who are not a number means, when of my IF() Functions returns false &lt;-- how could I ignore this value, that my MIN() Function will give me a valud resulst back - and not 0</p>
  
  <p>???</p>
  
  <p>Thanks for any help!</p>