variable ranges in slope

[Mike Harris]

today I want the fomula to be: =slope($e$1510:$e1516,$r$1510"$r1516) and

tomorrow I want it to be: =slope($e$1510:$e1517,$r$1510"$r1517) and

I want it to "grow" each day. I cannot find a way to make this happen. Can

anyone help?

Thanks,

Mike Harris

 

[Harlan Grove]

today I want the fomula to be: =slope($e$1510:$e1516,$r$1510"$r1516) and

=SLOPE(OFFSET($E$1510,0,0,N,1),OFFSET($R$1510,0,0,N,1))

where N = 7.

tomorrow I want it to be: =slope($e$1510:$e1517,$r$1510"$r1517) and

=SLOPE(OFFSET($E$1510,0,0,N,1),OFFSET($R$1510,0,0,N,1))

where N = 8. One formula, one variable parameter, N. Make N another cell, change
it, and your formulas change.

 

[Mike Harris]

Thanks, Harlan!

Mike Harris

...

=SLOPE(OFFSET($E$1510,0,0,N,1),OFFSET($R$1510,0,0,N,1))

where N = 7.


=SLOPE(OFFSET($E$1510,0,0,N,1),OFFSET($R$1510,0,0,N,1))

where N = 8. One formula, one variable parameter, N. Make N another cell, change
it, and your formulas change.