Not sure why the row and column markers didn't come through, but the status bar is hilighted on cell B5 (the first value in the 2nd Column...column B).

I've scratched my head, because I can see the IF (logic) operator and I'm pretty sure I'm understanding the convention logic...it's saying..."IF the value is null, then output "" (blank)" if the value is not null, then output the average of ......Column A, then it calculates the start row, and the end row.

But I can't even reverse engineer where it's getting the value. I've tried to see if it's averaging the wrong set of values, if it's cutting the average sample short, or adding extra...etc.

I'm really scratching my head.......but the convention is working swimmingly, if I put 20 into the input cell, it begins populating values at B20 (and leaves B1 through B19 blank) it's just giving me the wrong output values.

Not that you haven't helped enough already,

But I'd like to do a second average of the average to smooth out the MA.

So I'm adding a second input cell (next to the 1st iteration).

It's working, but it's averaging the null values from the first row (essentially, if I use a 20 MA and then try to calculate a 20 MA of that MA, it's spitting out values at row 20 and using the first 19 null values from the MA column).

How can I modify the IF statement to exclude the null values from the previous column?

Hi,

I have been working in somenthing similar, but i have the same problem for change the sma. I post a file for someone can help.

Thanks

Did you get it working?