is there a way to use the last $value entered in a row.
here is an example.

I have my last $value calculated on F6. lets say the value is $700, which is dependent on values entered in D6 and E6.
It maybe days before new values are entered thus values in the F row would be blank.

I'm try to setup this row so that when new data is entered it uses the last value that was calculated.
So F6 has a value.
F7-F9 are blank.
When new enteries are entered on D10-E10, F10 uses the last cell above that has a value. I this case it will be F6 as F7-F9 are blank.

Is there a built in function that will do this?