My eyes are falling off now. I tried everything below but my question is not
answered

Excel build in formula
Tool => Option => Calculation => Percision as displayed. It crashed my
excel.
Searched web but most usergroup posting is dated back in 1990's

Problem:

Formula is entered to calculate % of total. If % is added up manually, the
number doesn't add up to 100%. Does anyone have a costum formula that
automatically roundup or rounddown any % so the total add up to 100%?

Example:

A + B + C + D + E + F
= Total
$15,129 + $20,030 + $48,858 + $26,353 + $15,275 + $32,805 = $158,451

Using Round(X,2) to calculate % of total

10% + 13% + 31% + 17% + 10% + 21% = 102%, Not
100%