title: Last Value of a Column but When It Is a Column of Formulas
body: <p>I have tried everything on the web.
  I have a column of formulas that display either a number or <code>""</code>.
  I want to get the last VALUE from this column range.</p>
  
  <p>Column is B8:B108 and the cells contains a formula like: </p>
  
  <pre><code>=if((ROW(B9)-8) &lt; $G$9, if((ROW(B9)-8) &lt; ($G$9-$G$10), B8*(1+$C$3), B8*(1-$C$2)),"")
  </code></pre>
  
  <p>This will return a number or <code>""</code> to the cell.</p>
  
  <p>Every example online I can find has a solution for when the cells are just number or empty, not when the cells contain formulas that compute numbers or <code>""</code>. </p>