Forum Discussion
Spread a Number over multiple cells and calculate growth
karim1974 Attached a workbook that follows the logic of what I believe is what you explained. With considerably lower monthly growth %% and a higher first month revenue, I could approximate the yearly revenue targets.
If this makes no sense alt all, kindly clarify.
Thank you so much for your input. This is close but not 100% what I am looking for.
if I consider your form, I only want to be able to input manually the July value and then the model should automatically consider the revenue of 2022 and spread the values and calculate automatically the growth rate
so by Inputing July value manually the model needs to consider the $1,000,000 Revenue of 2022 and substract the value of July and spread unequally the remaining into August to December months and generate automaltically the growth that was calculated to go from July to December to reach the 1,000,0000
The year after 2023, the model will consider the December 2022 value and the revenue value for 2023 in table 1 and repeat the process from January to December
so this model will only take one manual input which is the July 2022 value...all other values and yearly growth rate are calculated automatically.
karim1974 Well, good luck! I'm not going to be able to help you with that. Sorry.
