title: Ignore blank cells excel using if
body: <p>I honestly don't see what I am doing wrong here. I am trying to see the minimum between three cells, and I want the result to ignore if one of those cells is blank or return nothing if they are all blank. </p>
  
  <p>I've tried (with an without spaces between the "")</p>
  
  <pre><code>=IF(ISBLANK("B21,B26,B31")," ",MIN(B21,B26,B31))
  </code></pre>
  
  <p>This gives me 0 if my cells are blank</p>
  
  <p>I also tried</p>
  
  <pre><code> =IF((ISBLANK("E21,E26,E31"))),(MIN(E21,E26,E31),"")
  </code></pre>
  
  <p>Which doesn't do anything. I don't know how this can be wrong and it's obviously not a difficult problem but I can't seem to crack it despite the huge number of people who have asked similar questions before. </p>
  
  <p>Thanks in advance</p>
  
  <p>Lilou</p>