Rounding in Formula

ssteeve
ssteeve
edited 12/09/19 in Formulas and Functions

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:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!