I have odd numbers in a spreadsheet that I need to multipy by percentages and then have those solved numbers all add up to the orginal odd number. Example: 3,541.67 x 50%, x 25%. and x 25% gives me the answers of 1,770.84, 885.42, and 885.42. Those three answers add up to 3,541.68, not 3,541.67. I have tried the ROUND function but that doesn't help. I know there must be an easy answer but don't know how to search for it.