Round and % formulae

Gaurav Chauhan

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%

Mike TV

@Gaurav Chauhan

Does this work?

=ROUNDDOWN(INDEX(COLLECT({Profit Margin}, {Program Name}, CONTAINS([Program Name]@row, @cell)), 1),2)+"%"

Gaurav Chauhan

Hi, thank you for the help.. But adding ROUNDDOWN leads to INVALID