Use a function to round all bar one of your values to whatever degree you
need, and then have the last value be the total minus the summation of the
others.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"jesterhs" wrote in
message ...

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