Round and % formulae


Can you please check this formulae below. I need to round up the value to 2 digits and add %

=INDEX(COLLECT({Profit Margin}, {Program Name}, CONTAINS([Program Name]@row, @cell)), 1)

Currently the value output is 41.395

Expected results is 41.39%


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!