I'm a not very advanced excel user, trying to figure something out.
In my attached spreadsheet, I want to take $10 and have it follow the daily returns listed on column D. Each day would add or subtract a % of the previous day's total. I did a couple calculations manually to show what I mean. Thanks for any help you can give!
Welcome to the forum.
Try this copied down:
=$C$2+(SUM(D$3:D3)*10)
Last edited by AliGW; 10-25-2021 at 09:39 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
HI,
Check this file
E3=$C$2+D3*C2
E4=E3+E3*D4
Punnam
Thanks for the help!Originally Posted by AliGW
Welcome to the forum.
Try this copied down:
=$C$2+(SUM(D$3:D3)*10)
This seems close, but slightly off. For E5 it is giving me $10.89 and my hand calculations are giving me $10.91 and I think it snowballs from there.
It looks like this works, but is there an easier way to fill it down the column than dragging it? Thanks!
Once you have entered the formula into cell E4 double click the fill handle for that cell and Excel should automatically fill down as far as the last row in column D that has a value.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks