flattie007387068
2009-12-11, 07:30 PM
I have two tables in 2010.
Table-1 has three cells, cell A1, A2 & A3. Each contains 1000 as the value. This data is keyed in manually.
Table-2 also has three cells, A1, A2, A3. This table is suppose to be dynamic, based on the changes of Table-1.
I'd like cell A1 on table-2 to take the values of table-1 (A1 + A2) and return the value of 2.0
I'd like cell A2 on table-2 to take the value of table-1 (A3) and return the value of 1.0
I'd like cell A3 on table-2 to take the value of table-2 (A1 + A2) and return the value of 3.0.
How would I go about doing this? I'm pulling my hair out trying to figuring it out, and all I've been able to come up with on table-2, for each cell are the numbers 2000 (A1), 1000 (A2) and 3000 (A3). I've gone as far as adding a point in between 2.000 (T2/A1) & 1.000 (T2/A2) which results in 3.000 (T2/A3) and no way to remove the trailing 0's so that the result is 3.0.
Table-1 has three cells, cell A1, A2 & A3. Each contains 1000 as the value. This data is keyed in manually.
Table-2 also has three cells, A1, A2, A3. This table is suppose to be dynamic, based on the changes of Table-1.
I'd like cell A1 on table-2 to take the values of table-1 (A1 + A2) and return the value of 2.0
I'd like cell A2 on table-2 to take the value of table-1 (A3) and return the value of 1.0
I'd like cell A3 on table-2 to take the value of table-2 (A1 + A2) and return the value of 3.0.
How would I go about doing this? I'm pulling my hair out trying to figuring it out, and all I've been able to come up with on table-2, for each cell are the numbers 2000 (A1), 1000 (A2) and 3000 (A3). I've gone as far as adding a point in between 2.000 (T2/A1) & 1.000 (T2/A2) which results in 3.000 (T2/A3) and no way to remove the trailing 0's so that the result is 3.0.