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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dragging a formula down isn't working - where am I going wrong? 1
Anchor issue with inserting a shape for letterhead 1
Excel Formula question 0
Drag Down Formula Incorrect 3
Combining an IF with another formula 4
Locking a cell reference in a formula 1
SUM FORMULA- skipping every seventh row 1
Array formula lock-up 1

Top