How to drag so part of a formula counts up and another down.

S

shada

Am trying to calculate autocorrelation coefficients for lags without changing
every formula so it's correct.
 
A

Arvi Laanemets

Hi

You didn't give us the rules how coeficients are changing, but principially,
for a function
YourFunction(ParameterUp,ParameterDown) you can use something like

=YourFunction(MIN(const1+const2*(ROW()+const3),MaxParameterUp),MAX(const4-co
nst5*(ROW()+const6)))
 
A

Arvi Laanemets

Sorry

=YourFunction(MIN(const1+const2*(ROW()+const3),MaxParameterUp),MAX(const4-co
nst5*(ROW()+const6),MinParameterDown))
 
Top