For the last numerical value, try...

=LOOKUP(9.99999999999999E+307,B2:B65536)

Hope this helps!

In article ,
ssipiora
wrote:

I'd like to create a formula that always uses the last number in a
column for a calculation. That way when I add new daily data I
automatically get my calculation.

I'd rather not have another column doing this because I just need one
number, I just need it updated every day based on additional data.

Thanks