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) + "%"
-
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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!