HI guys, is there any function I can use to distribute a value across the number of periods across which I apply the same formula ?
- I know I want to spend 1.000€ for a project
- the exact duration across which I’m going to spend this is up for discussion
- I’d like to be able to easily adjust the time span by narrowing in or expanding the “merged cells” across which spending occurs.
- In order to keep things tidy I’d like to refrain from adding “start date” and “end date” variables (as we’d have a whole load of such start/end dates then, cluttering things up too much).
Thank you & Best Regards