Rounding in Formula

ssteeve

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å

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

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

Thank you both for your help. Solution successfully implemented.

Paul Newcome

Happy to help! 

Andrée Starå

Excellent!

Happy to help!