auto round up or down to sum to 100%

I have sales figures from each region and need to convert those to percentage. and then when i try to add up those percentage shown on screen in excel, sometimes they will add up to 100.1% or 99.9%. Then i will have to manualy adjust the one that excel didn't round up but larger comparable to other regions in the 2 dp.

please see attached pic. thanks.