Formulas in Excel?

Question

II need to be able to link table A to table B. That when I will put a letter as "x" under L750 (TABLE A) the quantity in table B will varie, the achieved should get up and the colum in table B for L750 or M750 will get down. Please see the example below. Could someone tell me how they which formulas I will be able to use in excel to do this?

Table A
qsoc 2
region 3
AgeGroup 2
L750 x
M750


Table B

AchievedL750AchievedM750TOTAL
Social Grade1158158316
2135135270
293293586

Gender1
2586
586

Age Breaks199100199
2103102205
39191182
293293586
Region1141529
2272653
3202141
4121123
55556111
6272653
7262753
8333265
9141529
10272653
11383876
293293586

Answer 1

I hope I understand your question. The way I read it, you want to put a character like "X" in a cell and have it tally and add to an existing number in one cell and subtract from an existing number in another cell. If you put multiple characters in that cell, it should reduce and increase those other cells by the amount of the characters entered respectively.

First, I suggest you put your tally characters in one cell separate from any other labels or numbers. Then in the cell where you want the amount to increase here is the formula. For example lets say you have an existing number of 200 and you want to add the number of tally marks (X's) entered in the cell D3.

In the cell where you want the increased number the formula would be =200+Len(D3). Now if you put five X's in cell D3, the number would show 203 after calculation. (usually calculation is automatic in Excel.)

In the decreasing example the formula would be =200-Len(D3). The only difference is the minus instead of the plus sign. Be sure to put this formula in a different cell so you can see the increasing and decreasing figures at the same time.

I hope this helps you.