Take a look he
http://www.mcgimpsey.com/excel/pennyoff.html
In article
<gregorio_gomez7.1rejed_1120071914.0822@excelfor um-nospam.com,
gregorio_gomez7
<gregorio_gomez7.1rejed_1120071914.0822@excelfor um-nospam.com wrote:
i designed a workbook i use to calculate the percentage of a fixed
benefit amount to more than 1 beneficiary. i have had problems
controlling the results, for example, 33% of $100.00 produces a results
that when added do not produce an even $100.00. what is the best method
for resolving this issue? please help me. thank you. :)