Increase value formula

  • Thread starter Thread starter GerryK
  • Start date Start date
G

GerryK

I'd like help with a formula that would increase the value
in A2:C2 proportionately by what is in D2:F2.

A2:C2 would then =100% of a budget that was distributed as:

Productivity
A2=28%
B2=24%
C2=18%

Support time for production
D2=15%
E2=8%
F2=7%

TIA
 
Gerry

One way:

In A3:

=A2+(1-SUM($A$2:$C$2))/SUM($D$2:$F$2)*D2

Copy A3 to C3 with the fill handle (the little square
in the lower right corner of the cell)
 
Back
Top