Round and % formulae

Options

Hi

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%

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!