title: How can I make Excel's MIN function ignore zeroes in a set?
body: <p>In Excel, I have the following formula <code>=(MIN(H69,H52,H35,H18)*(1/H18))*10</code> that is supposed to return the <code>MIN</code> of a range, and divide it by the current cell (*(1/H18) ), then multiply by 10.</p>
  
  <p>I am having difficulty with adding a type of NULLIF statement. I want to be able to have (the possibility for) blank rows, and have the MIN function ignore zero/blank fields while selecting the next lowest value (all are between 1.0-0.1).</p>
  
  <p>Is there a modifier i can apply to the MIN function to make it not compare zeroes in the MIN set? Is there a better function than <code>MIN</code> to use?</p>
  
  <p>Here is the arrangement:
  <img src="https://i.stack.imgur.com/zuzF3.png" alt="alt text"></p>
  
  <ul>
  <li>Please remember to include the syntax for where the <code>MIN</code>'s set goes</li>
  <li>The reason for the <code>H69,H52,H35,H18</code> using commas is that these are embedded, individual cells that are arranged for visual presentation as well. Using a range, or colon/semi-colon operators don't appear to work for this purpose (see pic).</li>
  <li>This is to prevent the following situation: <em>users</em> will need to eliminate fields that are zeros from the form, theres 2 formula edits per entry, averaging 4 entries per use, so 8 possible errors per form use...</li>
  </ul>