call us today: 1.800.876.8376
email us:
The following formula will perform a weighted smooth function on every 5 points, such that points 1 and 5 have a weight of .1, points 2 and 4 have a weight of .3 and point 3 has a weight of 1. Before running the formula, select all but the last four cells in the input column.

cell(index(), 1)=(cell(index(),0)+3*cell(index()+1, 0)+10*cell(index()+2, 0)+3*cell(index()+3, 0)+cell(index()+4, 0))/18;

Mark as helpful.

Posted in: Formula Entry: Advanced formulas