Rounding in Formula

ssteeve · 09/12/19

I would like to round the result of this formula.

=(ROUND(SUM([KR1 Calc]7, [KR2 Calc]7, [KR3 Calc]7, [KR4 Calc]7, [KR5 Calc]7)) / 3 + "%")

KR1 Calc]7 = 0

[KR2 Calc]7 = 100

[KR3 Calc]7 = 100

[KR4 Calc]7 = 0

[KR5 Calc]7 = 0

Currently returning = 66.66667%

I would like to round this to = 67%

Andrée Starå · 09/13/19

Hi Steve,

Have you tried removing the +"%" part and formatting the cell(s) with Percentage Format instead?

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome · 09/13/19

You could also try including the "divided by 3" portion in the ROUND statement.

=ROUND(SUM([KR1 Calc]7, [KR2 Calc]7, [KR3 Calc]7, [KR4 Calc]7, [KR5 Calc]7) / 3) + "%"

ssteeve · 09/13/19

Thank you both for your help. Solution successfully implemented.

Paul Newcome · 09/13/19

Happy to help!

Andrée Starå · 09/13/19

Excellent!

Happy to help!

Comments