IFERROR Formula for Dividing By 0

Options
Tony Barthelemy
Tony Barthelemy ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Happy Friday All:

I am trying to replace IF Formula with IFERROR so I do not receive #DIVIDE BY ZERRO Error. However, I receive Incorrect when I use the IFERROR. Can anyone help?

Existing Formula:

=IF(AND(TODAY() >= [Start Date (Planned)]18, TODAY() <= [Finish Date (Planned)]18), ROUND(NETWORKDAYS([Start Date (Planned)]18, TODAY()) / Duration18, 2), IF(TODAY() > [Finish Date (Planned)]18, 1, 0))

 

Attempted Formula:

=IFERROR(AND(TODAY() >= [Start Date (Planned)]18, TODAY() <= [Finish Date (Planned)]18), ROUND(NETWORKDAYS([Start Date (Planned)]18, TODAY()) / Duration18, 2), IF(TODAY() > [Finish Date (Planned)]18, 1, 0))

 

Thanks

 

 

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!