Message #1 Posted by VGreen on 10 Feb 2005, 9:32 a.m.
Here's the problem:
(A) I have six values: 1,2,8,6,4, and 9, and I want to subtract 2 from 1, 8 from 2, 6 from 8 etc., and I want to assign (1) to my first answer and (2) to my second answer, i.e., 1=-1; 2=-6; 3=2; etc. I want to be able to enter the six values one after the other and then obtain the result.
(B) I would also like to store all the negative results in one column and all the positives in another and access them later. I would also like to store the sum of the negatives and the sum of the positives in separate columns and access them later.
(C) Finally, I would like to take value 1 and add it to result 1 and store it; value 2 and add it to result 2 and store it in the same column as the previous one, etc., so I can bring up a column of all the results later.
Any assistance would be greatly appreciated.