IFERROR
Hi
Can anyone help me with an IFERROR formula please to get rid of the #DIVIDE BY ZERO message. I've tried several example off the internet but just keep getting incomplete argument or imparsable messages
This is the formula i have that returns the error message
=IF([Completion Date]@row = "", ROUND([DAYS SINCE START DATE]@row / [TOTAL DAYS]@row * 100, 0), "COMPLETE")
Thank you
Best Answer
-
You would wrap the whole thing like so:
=IFERROR(original_formula, "")
Answers
-
You would wrap the whole thing like so:
=IFERROR(original_formula, "")
-
Morning Paul
Thank you so much, after messing for ages this worked right away. Thank you again for your help
Barry
-
I wasn't closing the original formula before putting the ,"") but adding the ,""then closing everything with 2 sets of brackets ,""))
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 440 Global Discussions
- 138 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 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!