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

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

Guest

Am trying to calculate autocorrelation coefficients for lags without changing
every formula so it's correct.
 
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)))
 
Sorry

=YourFunction(MIN(const1+const2*(ROW()+const3),MaxParameterUp),MAX(const4-co
nst5*(ROW()+const6),MinParameterDown))
 
You must log in or register to reply here.

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

Excel Drag autofill only part of formula 3
using the =page! feature to transpose a row to column 0
Locking a cell reference in a formula 1
drag formula down from columns that go acros 3
Excel Dragging countif formula with changing criteria 3
Display Coefficients of a Polynomial Trendline 3
Dragging a formula in a column 1
cell reference of a formula 2

Back
Top