Thank you for responding! Adding all and rounding at the end isn't
going to be an option. Each number is representative of the asset
allocation of an investment fund. So I actually need to make the
determination of which funds to round separately and not round the sum.
I'm sorry I didn't mention it before. The formula is going to have to
look at all the funds in the scenario, check to see if the sum is < .1,
"Begin rounding the highest number", then check again to see if sum <
.1, if so then exit the "loop".
Any other ideas?
--
AMarie
------------------------------------------------------------------------
AMarie's Profile:
http://www.excelforum.com/member.php...o&userid=27924
View this thread:
http://www.excelforum.com/showthread...hreadid=474763