I have the following formula =B4+(B8*(C8*D8)) to calculate a balance for a fake Stock Market account.
B4 is the starting balance. B8 determines buy or sell (1 or -1) C8 is the volume D8 is the price paid
I want to be able to do this calculation for 100 or 200 rows. Is there a way to rewrite this formula but use a range.
Basically I want an easier way to write this =B4+((B8*(C8*D8))+(B9*(C9*D9))+etc,etc)
Thanks for the help.
I forgot to mention this formula is applied to cell D4. This is the current balance cell.