title: Function to Compare Two Cells and Return the Smaller in Excel
body: <p>I'd think there'd be something to do this in Excel, because it seems so basic... BUT:</p>
  
  <p>I have two cells and I need to compare them and return the lower of the two. This is very easily done with the following:</p>
  
  <pre><code>=IF(A1 &gt; A2, A2, A1)
  </code></pre>
  
  <p>But in a complex formula, this seems insanely unnecessary.</p>
  
  <p>It's also possible to do with:</p>
  
  <pre><code>=SMALL(A1:A2)
  </code></pre>
  
  <p>But of course my cells are not adjecent and don't make a range.</p>
  
  <p>Thoughts?</p>