title: Excel formula for min value if greater than negative number and less that positive
body: <p>I need some help with a formula. I'm trying to work out the minimum value if greater than -365 but less that 365.</p>
  
  <pre><code>{=MIN(IF((E46:J46&lt;365)*(E46:J46&gt;-365),E46:J46))}
  </code></pre>
  
  <p>This is the formula I have so far, which is ignoring anything less that -365 and anything over 365.</p>
  
  <p>It gives me the correct value if the minimum is less than 0 but anything greater than 0 is getting ignored, and the cell displays a 0.</p>
  
  <p>For example,</p>
  
  <p><strong>E</strong> -42101<br>
  <strong>F</strong> 80<br>
  <strong>G</strong> -35<br>
  <strong>H</strong> 367<br>
  <strong>I</strong> "blank"<br>
  <strong>J</strong> "blank" </p>
  
  <p>Then I will get -35 as my minimum value, if I delete this from the cell my minimum values turns to 0, when it should be 80.</p>
  
  <p>Thank you in advance.</p>