Percentage formula does not work if denominator is zero
Hi, I have the formula for percentage but when denominator is zero, instead of showing 0%, it does not show anything. How can I make it such that it returns zero if that is appropriate so that my run chart does not look like its missing data points? Thank you!
Answers
-
Post your formula so we can see what you have and help you figure out the issue.
Jonathan Sanders, CSM
"Change is always scary because it is unknown, but facing the unknown is what makes us stronger."
-
It sounds like you have an IFERROR built in. If so, try adjusting the output of that to zero instead of blank.
=IFERROR(percentage_formula, "")
adjusted to
=IFERROR(percentage_formula, 0)
-
Here is the formula =[May FY23]2 / [May FY23]3 * 100
-
@Paul Newcome thank you for your response, I see that you shared a formula which is =IFERROR(percentage_formula, 0). My current formula is =[May FY23]2 / [May FY23]3 * 100. How should I write the formula, with your input? Thanks so much.
-
Hi @APete
I hope you're well and safe!
Try something like this.
=IFERROR([May FY23]2 / [May FY23]3 * 100, 0)
Did that work?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@APete It would look like this:
=IFERROR([May FY23]2 / [May FY23]3 * 100, 0)
-
hello! I want to piggy back on @APete 's question but using my formula? @Paul Newcome how would you fix this formula as I also would like this to result to 0% when I have a ZERO denominator. Thanks in advance!
=([Helper%Complete]@row / Duration@row)
-
@Harley Esguerra You would use the IFERROR exactly as I suggested in my last comment.
-
Thanks @Paul Newcome that worked but one final question. I applied the same formula to the below question but I am getting a blank cell when the denomonitor is 0%. The cell that I put this formula into btw is "date" formatted. What would the workaround be for this?
=IFERROR([eStart Date]@row + (Duration@row / [HelperCPI%]@row), 0)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!