Thread
:
redistributing figures based on %
View Single Post
#
2
DOR
Posts: n/a
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=""))))
Reply With Quote