1) I suspect you meant 80%, since 23.2=.80*29. .85*29=26.45. It isn't
the problem in this case, but make sure your percentages add up to
100%.

2) This is the hazard you run into when rounding, especially when
rounding intermediate calculations. If you try it with 30, you get 31.
Is there some reason you must round the numbers? Barring other
constraints, I would suggest formatting the cells to display 0 decimal
places. When you use a number format, the underlying cell's value
isn't changed. In other words, 23.2 displays as 23, but the cell's
value is 23.2. Then when you add up the three cells, you get 29
instead of 28. This all assumes that the cell calculation option
"precision as displayed" is not checked.


--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181
View this thread: http://www.excelforum.com/showthread...hreadid=389210