Nesting SUM, Decimal places, and %

I'm attempting to calculate the percentage of work that's done, round it to a whole number, and add a percent sign. I can get 2 of any 3, but not all three.

=SUM(([Points Done]@row / [Total Points]@row) * 100)

Adding + "%" to the end of the equation gives me 5 decimals.

I'd also like to add an IFFERROR for when there are no points. How do I nest all these together?

Tags:

• Let me ask a different way:

=SUM(([Points Done]@row / [Total Points]@row)) results in .63636

=SUM(([Points Done]@row / [Total Points]@row) * 100) results in 63.636363

=SUM(([Points Done]@row / [Total Points]@row) * 100)+ "%" results in 63.636363%

1) How do I specify no decimals, and have a percent sign?

2) If the Points column is empty, how do I incorporate an IFERROR to have a custom message?

3) Anyway to have this in one equation?

My attempts to combine them haven't worked.

Thank you!

• ✭✭✭✭✭✭

Have you tried formatting the column as Percentages using the % option in the toolbar?

Use the first formula that results in .63636 and send me a screenshot of the final result!

• I completely missed that button! Thank you, it works perfectly.

This IFERROR works now also, thanks for your help.

=IFERROR(SUM([Points Done]@row / [Total Points]@row), "Unpointed")

• ✭✭✭✭✭✭

Awesome. Glad I could help. Please mark my answer as best answer if you think it resolved the situation for you. Have a great day!