Formula needed: "last entered value divided by x cells back"

[MortenAH]

Hi,

Is there a formula that automatically looks up the most recently entered value (here: 8 (Col F)) and then looks three cells to left (here: 3 (col D)) and divides it by that? In this example the result would be 8/3.

Col A Col B Col C Col D Col E Col F
Row1 2 4 6 3 7 8


Thanks in advance!!

BR
MortenAH