Last Value of a Column but When It Is a Column of Formulas

I have tried everything on the web. I have a column of formulas that display either a number or "". I want to get the last VALUE from this column range.

Column is B8:B108 and the cells contains a formula like:

=if((ROW(B9)-8) < $G$9, if((ROW(B9)-8) < ($G$9-$G$10), B8*(1+$C$3), B8*(1-$C$2)),"")

This will return a number or "" to the cell.

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 "".