Hello, I am trying to repeat a formula across X cells, where X is a variable defined in another cell.
For example, in the image below I am investing $100 evenly over 4 years. I want to automate the sheet so that if I change J1 to, say, 5, the sheet will automatically populate the formula over five cells A2 to E2.
Thank you!
For example, in the image below I am investing $100 evenly over 4 years. I want to automate the sheet so that if I change J1 to, say, 5, the sheet will automatically populate the formula over five cells A2 to E2.
Thank you!