Precentage out of 2 cells
Hi,
Current formula is:
=[Column A]@row/[Column B]@row
How do I add a precentage at the end I.e. 99% or 100% and not 5.2554...
Thank you!
Best Answer
-
Hi @Paul Newcome,
Thanks for your assistance on this,
What worked best for me was this simple one..
=IFERROR([Column B]@row/[Column A]@row, "")
Then made it to a precentage column from the ribbon.
Thank you!
Answers
-
Hi there,
In the tool bar change the formatting of the cell to %
AJ.
-
Hi,
but then the numbers aren't just 2 digits when i change to "%" the numbers are 14.xxxxx
how do I remove that?
Thank you!
-
Use the increase decimal / decrease decimal button to format the column to your desired number of decimals.
-
When decreasing decimal, 7.88889 becomes 7.89, when turning on precentage it becomes 789%
Any resolution to have both "7.89%"?
Thank you!
-
Try this...
=ROUND([Column A]@row/[Column B]@row, 2) + "%"
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi @Paul Newcome,
Thanks for your assistance on this,
What worked best for me was this simple one..
=IFERROR([Column B]@row/[Column A]@row, "")
Then made it to a precentage column from the ribbon.
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!