Hello
Can someone help me with a formula for the below
A1: 240,000 (last years sales)
B1: 360,000 (next years sales forecast)
C1:N1: next years sales forecast by month (Jan-Dec)
I need a formula to calculate the monthly sales in cells C1:N1. I can obviously just divide the 120k increase by 12 and apply this but what I'm trying to achieve is a even month by month growth rate over the year.
For e.g.
Jan: 245
Feb: 255
Mar 270
Can anyone help?
TIA
Bookmarks