Thread: fraction
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default fraction

That might cause the integer parts to change as well. Maybe (even likely) that doesn't matter, but it's not what the OP asked.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Excelenator" wrote in message
...
|
| Set a cell that sums the amounts you listed. USe the Solver Addin to
| force the sum to be 641. This works great and even prepares a report
| that shows the original values and what they became.
|
|
| --
| Excelenator
|
|
| ------------------------------------------------------------------------
| Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
| View this thread: http://www.excelforum.com/showthread...hreadid=567994
|