Conditional run total

[Pirasant]

Hi!

I have a bit complicated problem I can't seem to figure out. 

This is the data I have 

Company Name	Round	Investment	Share price 1	Share price 2
x	1	100	3	3
x	2	200	3	4
x	3	300	3	5

This is the output I want, where I want to adjust the new shareprice compared to the "last round" except for the first round: 

Company Name	Round	Investment	Share price 1	Share price 2
x	1	100 * 3/3	3	3
z	2	200*4/4 + 100*4/3	3	4
y	3	300 *5/5 + 200 *5/4 + 100*5/3	3	5

[jzkyburz]

@Pirasant have you tried using a Multi-Row Formula? This will allow you to reference rows ahead or behind the active row in each calculation. This could become challenging as you scale with additional rounds..

[BRRLL99]

Could you please post some additional data

this can be done using multi-row formula

[Emmanuel_G · Accepted solution]

Hi @Pirasant,

Find attached the solution to this issue.

Let me know if there is any issue and please do not hesitate to mark this answer as solution if it helped.