| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Count [An+1]=[An]+1 With A2 set at 1 | A running total of A =sum([$A$2]:[An]) | Difference between one cell and the rest =[An]-[$A$2] | A running average =average([$A$1]:[An]) | A basic cross-column formula =An+Bn^2*Cn/($D$7) | If statement =if([An]<3,0,1) |
2 | 1 | 1 | 0 | 1 | 1 | 0 |
3 | 2 | 3 | 1 | 1.5 | 4.571428571 | 0 |
4 | 3 | 6 | 2 | 2 | 23.57142857 | 0 |
5 | 4 | 10 | 3 | 2.5 | 89.71428571 | 1 |
6 | 5 | 15 | 4 | 3 | 262.1428571 | 1 |
7 | 6 | 21 | 5 | 3.5 | 636 | 1 |
8 | ||||||
9 | ||||||
10 | ||||||
11 | ||||||
12 | ||||||
13 | ||||||
14 | ||||||
15 | ||||||
16 | ||||||
17 | ||||||
18 | ||||||
19 | ||||||
20 |