I'm trying to get the last value of the last non-empty cell in a column

Hello,
I'm trying to get the last value of the last non-empty cell in a column!
= LOOKUP (2; 1 / (A: A <> ""); A: A) the function works well for a column whose data is entered manually! The problem is when the cells in the column are formulas - then the result is 0
So how do we get the last numeric value from this column, knowing that all the cells in the column are formulas?


Thanks a lot !