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

Status Log Push to Dashboard
I want to push the latest status log sheet entry to the dashboard. I have added working columns for the last date, recent value (0 or 1) and recent status (text field). The recent columns are blank except for the most recent data rows (that part of the sheet is working). I have a project metric sheet template across topics…
Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
Sheet Summary Formula
I am looking to count how many letters we have issued within each month, this is by going by the modified date, these are the formulas i have tried as i want to start this from August: =COUNTIFS(Modified:Modified, MONTH(@cell ) = 8, Modified:Modified, YEAR(@cell ) = 2025) However, it comes up with an error. Any ideas…