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 |
Solved! Go to Solution.
@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..
Could you please post some additional data
this can be done using multi-row formula
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.