Convert to Percent

Gaurav Chauhan

Hi Team, I have a formuale in one sheet cell that is bring in a value from another sheet through Index/Collect.

I need to convert the transported value into percentage.

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

I need to convert this to 50%

1. Add a % and 2. No decimals.

Can you help.

Sameer Karkhanis

You can use the column formatting (percentage format) which is one of the last few icons in the toolbar (expand the toolbar if you see ...).

Gaurav Chauhan

Thank you. Is there any other way wherein the output of formuale converts to percentile

Paul Newcome

You would wrap the whole thing in a ROUND function then add the % symbol, but this will convert it into a text string that cannot be used as a number for further calculations.

=ROUND(INDEX(.........................)) + "%"

RobertZapata

Hi @Paul Newcome ,

This is robert again and wanted to get further assistance for the conversion to percentage of the values i have.

As you could see below

overall issue rows are 173 and out that i have 171 completed and 2 not completed i wanted to get a formula to do this as iam facing difficulty for the same.

Thanks

Rob.