On Nov 19, 5:03*pm, Neon520 wrote:
Here is what I understand from your tweak, it only
solve the problem when it is "more" than 100%
(1-sum(B1:B4),4), how can it solve the issue when
it's "less" than 100%?

It works in both cases. But the presumption is that sum(B1:B4) is
less than 100%. That might not be the case due to rounding. It would
be safer to replace ROUND with ROUNDDOWN.