fraction
 

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...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=567997

fraction
 

Assume you have your figures in A1:A23
In B1: =INT(A1)
Fill down to B23
In C1: =A1-B1
Fill down to C23
In E1: 1
In D1: =B1+($E$1*C1)
Fill down to D23
In D25:
=SUM(D1:D24)

ToolsGoal Seek
Set Cell: D25
To Value: 641
By changing cell: E1
OK

Now you have your figures in Column D to add to 641

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"b166er" wrote in message
...
|
| 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...o&userid=34912
| View this thread: http://www.excelforum.com/showthread...hreadid=567997
|