IFERROR

Fialko66 · 06/27/22

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

Paul Newcome · 06/27/22

You would wrap the whole thing like so:

=IFERROR(original_formula, "")

Paul Newcome · 06/27/22

You would wrap the whole thing like so:

=IFERROR(original_formula, "")

Fialko66 · 06/28/22

https://community.smartsheet.com/discussion/comment/334469#Comment_334469

Morning Paul

Thank you so much, after messing for ages this worked right away. Thank you again for your help

Barry

Fialko66 · 06/28/22

https://community.smartsheet.com/discussion/comment/334572#Comment_334572

I wasn't closing the original formula before putting the ,"") but adding the ,""then closing everything with 2 sets of brackets ,""))

Paul Newcome · 06/28/22

Happy to help. 👍️

IFERROR

Best Answer

Answers

Help Article Resources

Categories