View Single Post
  #2   Report Post  
DOR
 
Posts: n/a
Default redistributing figures based on %

Assume your layout as follows:

Original %s B1:B7, called OrigPc
Modified %s, C1:C7, called ModPc
In D1 put

=IF(C1,C1,(1-SUM(ModPc))*(B1/SUMPRODUCT(--(OrigPc),--(ModPc=""))))