Percentage Command Issue

How do I formulate a percentage in cell "Total Percentage" using division formula based on data from "Total Score" cell?

The "Total Score" cell correctly shows a result of 43. What I want to do is divide that number (43) by 50 with the end result of 86% displaying within another cell called "Total Percentage."

Total Score cell has existing formula below which extracts only the number from each of my ten survey question responses.

=SUM(VALUE(LEFT([Survey Question #1]1, 1)), VALUE(LEFT([Survey Question #2]1, 1)), VALUE(LEFT([Survey Question #3]1, 1)), VALUE(LEFT([Survey Question #4]1, 1)), VALUE(LEFT([Survey Question #5]1, 1)), VALUE(LEFT([Survey Question #6]1, 1)), VALUE(LEFT([Survey Question #7]1, 1)), VALUE(LEFT([Survey Question #8]1, 1)), VALUE(LEFT([Survey Question #9]1, 1)), VALUE(LEFT([Survey Question #10]1, 1)))

See attached screenshot.

Thank you

Find more posts tagged with

Formulas

Support

Comments

Vesta

Hi Bruce,

That total score formula is a doozy! I tested a way to turn your 43 into an 86%, and came up with a much simpler formula... =[Total Score]1 / 50. Then just format the Total Percentage column as a % from the tool bar, and it should work just fine for you. Hope this helps!

Vesta

Paul Newcome

Basically what Vesta said.

Take your current formula and then add

/ 50

to the end of it.

=current_formula / 50

This will give you a decimal which will convert to a percentage once you format the column as such.

Sign in to join the conversation!

Quick Links

Trending discussions

Lookup Value Issues
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
Separating Data into Multiple Rows
am I able to separate this into multiple rows? in a new sheet? Desired Result -
Index Distinct Support
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.