Convert to Percent
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.
Answers
-
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 ...).
-
Thank you. Is there any other way wherein the output of formuale converts to percentile
-
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(.........................)) + "%"
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!