I have two Columns

AC Tm% T%
DOMEQ 25% 26.5000%
INTEQ 17% 18.0200%
DOMPR 10% 10.6000%
INTPR 0% 0.0000%
ALTIN 0% 0.0000%
DOMFI 29% 30.7400%
INTFI 6% 0.0000%
DOMFR 10% 10.6000%
CASH 3% 3.1800%
Total 100.00% 99.64%


The Tm column is the original model percentages for each class. Class INTFI is to be excluded (6%) so I need to adjust each of the other % accordingly and still add up to 100. I thought you simply increase all other % by the excluded amount but I end up with 99.64.

The equation I am using fot T is =C15+($C$21*C15) where C21 is the 6% cell in Tm.

What am I doing wrong?

regards, mark