Growing data between 2 points

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone help?

I want to grow data between 2 points on a spreadsheet from a known start point (e.g JAN) to a known finish point (e.g DEC).

Is there a method that will calculate the data to grow incrementally by month from point 1 to point 2?

e.g

Jan 1,000,000
feb
mar
apr
may
etc

dec 1,500,000

Thanks!
 
Hi
not quite sure if this is what you want but if your january data is
stored in cell B1 and the december value in B12 enter the following
formula in B2:
=($B$12-$B$1)/11+B1
and copy down
Creates a fixed absolute growth amount per month
 
Back
Top