title: What does this formula mean in excel? (A cell equals a range)
body: <p>I see the following formula in a Excel spread sheet and can not understand... Can anyone explain what the test condition "N5=N4:N741" mean?</p>
  
  <pre><code>=MIN(IF(N5=N4:N741,K4:K741))
  </code></pre>
  
  <p>I made some experiments and still cannot get a clue...</p>
  
  <p><a href="https://i.stack.imgur.com/FKx28.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FKx28.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/s0WE9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s0WE9.png" alt="enter image description here"></a></p>