HI All
I wonder if someone can help me with this one.
I want to do some calculations using a fixed cell with other dynamic cells:
| | Field1 | Field2 | Field3 | (Explanation) |
| Row1 | A | 1 | 20 | |
| Row2 | B | 2 | 40 | (Row2,Field2 x Row1,Field3) |
| Row3 | C | 3 | 60 | (Row3,Field2 x Row1,Field3) |
| Row4 | H | 7 | 30 | |
| Row5 | I | 8 | 240 | (Row5,Field2 x Row4,Field3) |
| Row6 | J | 9 | 270 | (Row6,Field2 x Row4,Field3) |
| Row7 | K | 10 | 300 | (Row5,Field2 x Row4,Field3) |
| Row8 | X | 15 | 40 | |
| Row9 | Y | 16 | 640 | (Row9,Field2 x Row8,Field3) |
| Row10 | Z | 17 | 680 | (Row10,Field2 x Row8,Field3) |
The numbers in bold in Field3 are already there and those are the fixed calculation points, so its just the calculation to bring the red numbers in.
I'm sure someone can give me a solution to this.
Thanks in advance.
