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
- 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!