Find the Percentage of the Total
I have 4 columns that I have added together in the 5th, Total column (using =sum formula). Each of the 4 columns is a single dropdown select (values: 1-10). I want to translate the Total into a percent in the Percentage column, so I thought if I took the total value and divided by 40 (the max amount) in the % column, I would get the percent, but that does not work.
Would appreciate any insights on this.
Help Article Resources
Check out the Formula Handbook template!