I am having great difficulty in trying to write a formula to return the last negative number in a column.

Essentially, I am working with a file that requires constant updating and as I add rows, numbers vary between negative and positive. I would like to write a formula the exists off to the side, that will give me the very last negative number.

See below for an example

A1 1
A2 3
A3 -5
A4 -4
A5 3
A6 -2
A7 3

Below the data range, I'd like to write a formula that would tell me that -2 is the last negative number in the column.

Thank you so much for the help!!!