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 ,""))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 501 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 79 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
