fraction

B

b166er

hi members,

I want to know is there any way in ms excel through which i could get
desired result in sum or multiplication of fraction.
say if i add following figures i want to get answer 641 by adjusting
the fraction of all values accoringly.

2.335325
4.67065
7.005975
9.3413
11.676625
14.01195
16.347275
18.6826
21.017925
23.35325
25.688575
28.0239
30.359225
32.69455
35.029875
37.3652
39.700525
42.03585
44.371175
46.7065
49.041825
51.37715
53.712475
there sum should be 641 by adjusting all figures in the data
accordingly.
 
N

Niek Otten

Please don't post one question in separate posts to more than one newsgroups; people might spend lots of time to problems already
solved.
See my answer in other newsgroup.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| hi members,
|
| I want to know is there any way in ms excel through which i could get
| desired result in sum or multiplication of fraction.
| say if i add following figures i want to get answer 641 by adjusting
| the fraction of all values accoringly.
|
| 2.335325
| 4.67065
| 7.005975
| 9.3413
| 11.676625
| 14.01195
| 16.347275
| 18.6826
| 21.017925
| 23.35325
| 25.688575
| 28.0239
| 30.359225
| 32.69455
| 35.029875
| 37.3652
| 39.700525
| 42.03585
| 44.371175
| 46.7065
| 49.041825
| 51.37715
| 53.712475
| there sum should be 641 by adjusting all figures in the data
| accordingly.
|
|
| --
| b166er
| ------------------------------------------------------------------------
| b166er's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34912
| View this thread: http://www.excelforum.com/showthread.php?threadid=567996
|
 
E

Eddie O

I'm assuming you want to adjust each number by its percent of the total (i.e.
the difference between the actual and desired sum is applyied against the
numbers based on their size, with larger numbers getting a larger portion of
the difference applied).
Assuming the numbers you provided below are in range A1:A23, I put the
following formulas in the following cells:
A24 : =SUM(A1:A23)
A25 : 641 (not a formula, just the desired value to be adjusted for)
A26 : =A24-A25
B1 : =A1-(A1/$A$24)*$A$26 (I then copied the formula in B1 down
through B23.)
After you do the above, the numbers in column B will each by fractionally
adjusted to add up to your desired total.
 
Top