I have several columns of data, H9:H18, that have percentage values in them that I created by performing a division formula from other cells. What I need is to be able to have a grand total, cell H19, to be 100% and not change. Is there some way to force manipulate the totals of H9:H18 to change slightly to stay at a total of 100%. I'm always comming up 1% less or greater than I want.