Fluxtrix
Oct 5th, 2005, 08:57 PM
Hi just wondering if the following is possible in excel to do the following with these colums:
A B C
52.7 46.28 1,705.57
8.5 69.04 -146.67
16.8 55.63 201.15
3.4 109.73 -360.39
41 47.53 1,215.27
67.5 45.32 2,325.78
6.7 76.32 -222.10
6 80.34 -251.44
7.6 72.25 -184.39
12.3 60.65 12.57
8.1 70.38 -163.43
Total Of Column B = 733.47
What i have done above, to achieve the values in column C is to multiply the values in Column A x Column B then subtract the total of Column B from this Figure.
What i would like to know is, can i automatically make excel adjust the values in column B to show the minimum positive value in column C?
This may not make sense, i hope i have explained it properly.. please any response would be much appreciated
A B C
52.7 46.28 1,705.57
8.5 69.04 -146.67
16.8 55.63 201.15
3.4 109.73 -360.39
41 47.53 1,215.27
67.5 45.32 2,325.78
6.7 76.32 -222.10
6 80.34 -251.44
7.6 72.25 -184.39
12.3 60.65 12.57
8.1 70.38 -163.43
Total Of Column B = 733.47
What i have done above, to achieve the values in column C is to multiply the values in Column A x Column B then subtract the total of Column B from this Figure.
What i would like to know is, can i automatically make excel adjust the values in column B to show the minimum positive value in column C?
This may not make sense, i hope i have explained it properly.. please any response would be much appreciated