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
|