last value

[MrJim005]

In column A, rows 1 through 31 data is entered in those rows 1 through 31
corresponding to the day of the month. I need to return the value of the
LAST entered amount in column A to A35. How can I do this?

 

[Biff]

Try this:

=LOOKUP(100^10,A1:A35)

Biff