Growing data between 2 points

N

Nicky

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!
 
F

Frank Kabel

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
 
Top