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?

Best Answer


  • 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!

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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")

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    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!