Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #504 Apr 16, 2012 www.energyefficientbuild.com.
user orlando said:
sum percentage till 100% when phases are done.
hello, I have attached a sample spreadsheet, which I will use to explain what I will like to accomplish. If I have lets say four (4) phases which need to be completed, and I will like to see in a cell a percentage of completion of each phase based on the data on the row, how can this be accomplished. Will it be possible so that once one (1) phase is donde, a cell be marked with something like 25% or 1/4 etc. and when another phase is completed we the cell changes to 50% or 2/4 etc.??
https://docs.google.com/spreadsheet/ccc?key=0AlabHs3N3QIodFBpZ2UxME9WS1BXMkVyZG5BeElMckE
------------------------------------------------------------
following is a solution to the problem
user orlando said:
sum percentage till 100% when phases are done.
hello, I have attached a sample spreadsheet, which I will use to explain what I will like to accomplish. If I have lets say four (4) phases which need to be completed, and I will like to see in a cell a percentage of completion of each phase based on the data on the row, how can this be accomplished. Will it be possible so that once one (1) phase is donde, a cell be marked with something like 25% or 1/4 etc. and when another phase is completed we the cell changes to 50% or 2/4 etc.??
https://docs.google.com/spreadsheet/ccc?key=0AlabHs3N3QIodFBpZ2UxME9WS1BXMkVyZG5BeElMckE
------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment