With values in A2:A100

This formula returns the last numeric value in that range:
=LOOKUP(10^99,A2:A100)

...or...if there may not be any numbers...this formula has an error check:
=IF(COUNT(A2:A100),LOOKUP(10^99,A2:A100),"")

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"samoan" wrote:

have column of numbers. at bottom of column, want cell to display last number
in column. can't use max cause last number may be less than number above.
could use =if but can't next more than 7 formulas. possibility of 30 numbers
in column.


--
Tx,
Samoan