# Rounding in Formula

Options
edited 12/09/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%

Tags:

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

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

• Options

Thank you both for your help. Solution successfully implemented.

• ✭✭✭✭✭✭
Options
• ✭✭✭✭✭✭
Options

Excellent!

Happy to help!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!