Good Morning,
I am trying to figure out how to get 100% to spread out over 3 columns and also to have those percentages play off a total column and populate three other columns. For example:

Column A=Total Project Budget $$’s
Column B= cost of project 1
Column C=cost of project 2
Column D=cost of project 3
B+C+D=A
then
Column E=% project 1 is of A
Column F=% project 2 is of A
Column G=% project 3 is of A
E+F+G=100%
I need the sheet to be interactive so when I change %’s it changes the project dollars in B C & D columns

Thank you!!

    1 Response to "Percentage"

    • BenneTan

      Hi there. See if the file here is of help to you. what i did was:
      1) put in a formula for cell B2:
      =$A2*E2
      Copy it across to C2 & D2. This will calculate the Total Project Budget multiplies by the % of the individual project.

      2) Convert A1:G2 to a Table. To do that, select the said range & go to the “Insert” tab -> Table -> Check the option that “My table has headers”. As you add in data below, all the formulas from row 2 will be brought down too.

      The only manual entries to be filled are Column A, E, F & G. Does that help?

      here’s the link of the file:
      https://www.excel-course.com/wp-content/uploads/2013/02/Solutions_Distribution-of-Project-Budget-by-%.xlsx

Leave a Reply