Convert to Percent

Gaurav Chauhan · 06/04/22

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%

Add a % and 2. No decimals.

Can you help.

Sameer Karkhanis · 06/05/22

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 · 06/06/22

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

Paul Newcome · 06/06/22

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 · 04/27/23

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.

Formulas and Functions

Formulas and Functions

Convert to Percent

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Counting occurrences of values in a multi-select dropdown list

How would I write a formula to locate duplicates in 1 column and the difference in another column.

#NO MATCH result but not for identical formulas