formula to always disperse percentages to equal 100%

[bluke]

Hi,

I have a sheet with a calculation in Column K for rows 2-19 of (=$J2/(1-$H$22) H22 is static adjustment %. J2-J19 is a % of total for each task Line. I want to be able to change the static adjustment % in H22 and have the values change in column K but for the totals in column K not to exceed 1?

Is this possible? If so, how?

Thanks in advance for the help

bluke

 

[pbornemeier]

This will do what you asked for, but it will limit the K values to 1 by ignoring the H22 value:
=IF($J2/(1-$H$22)>1,1,$J2/(1-$H$22))