=IFERROR Issue
Hello,
I have an arithmetic formula that sometimes gives me a number, and other times does not depending on if the [Completed Milestone by Month] columns are populated.
When they are not populated they result in an error "Divide by Zero", which is fine. However I'd rather this not display on my dashboard. I've tried wrapping this in an IFERROR function, but it takes the bracket required to perform the division.
=([Completed Milestones by Month]3 - [Completed Milestones by Month]@row) / [Completed Milestones by Month]
=IFERROR([Completed Milestones by Month]3 - [Completed Milestones by Month]@row) / [Completed Milestones by Month], "-")
Answers
-
You need to add another opening parenthesis after the IFERROR function.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!