I presume you mean 80% not 85%
Just format the values you calculate to no decimal places. They will then be
displayed as 23, 4, and 1 but will still add up to 29 when you sum the
results since Excel 'remembers' the lost decimals, it just doesn't display
them.

"jesterhs" wrote:


ok, I can't seem to figure this out. I have a total, lets say 29. I have
to take 85%, then 15%, and finally 5% of that number (23.2, 4.35, 1.45).
If you add them back up in a 2 decimal format, no problems. But what if
I want to show the results without the decimals or rounded. 23, 4, and
1 only adds up to 28.

Is there a way to show these as whole numbers, possibly using a
function, and get them to add back to the total. It doesn't seem
mathematically possible, but I am hoping that there is some way.

Thanks,
Howard


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