Excel number in column

Question

I have a problem to be solved in Excel. I have three columns in Excel. The DX column is made up of numbers or sections. The DW column must be the result of a revaluation of the first number available in the DX column and so on. Once the first value has been obtained, in the DW column there must be another cell which will be the revaluation of the second available number of the column DX, multiplied by the values in the DV cells. I have to write the formula in DW and then pull it down, without the possibility of changing it. How can I do?

Example:

I am looking for the solution Many thanks

Right solution for the problem

2nd screen: 18958 is 9000 * (1+1,1064..) and 64916,05 is 32458,02 * (1+1)

Answer 1

Not sure how ,02 * (1+1) would give 0,05 but let's ignore that for a second..

EDIT: for older Excel and tbh also easier of a formula:
=IF(ROW(DX3)<4;"";IF(ISNUMBER(DV3);LOOKUP(2;1/($DX2:DX$3<>"");$DX2:DX$3)*(1+DV3);""))

LOOKUP example found here

---

Office 365:
Here's the formula to be pulled down:
=IF(ROW(DW3)<4;"";IF(ISNUMBER(DV3); LET(pmfFilter;DROP(SORTBY($DX$3:DX3;ROW($DX$3:DX3);-1);1);TAKE(FILTER(pmfFilter;pmfFilter>0);1)*(1+DV3));""))

You could shorten it by starting like $DX$3:DX2 but I don't like how that looks so instead, I opted for using DROP.
The SORTBY sorts the PMf range by row to reverse it and later use TAKE on to get the last number to calculate with.
The FILTER is because you get 0's in the array from the DROP(SORTBY.

Hope that helps :)