Increase certain amounts in proportion.

[rotown]

Hi, in the picture below I need to get cell E5 to equal 2% by increasing D2,3,4 & 6. I also must do this by maintaining the same proportion as shown in column C


I hope this makes sense?



Thanks in advance for any help!

 

[stapel]

Hi, in the picture below I need to get cell E5 to equal 2% by increasing D2,3,4 & 6. I also must do this by maintaining the same proportion as shown in column C


I hope this makes sense?

View attachment 4583

Thanks in advance for any help!

What is the full and exact text of the original exercise? What have you tried so far?

Please be complete. Thank you!