# How to make a number less than 0 show up as 0

Options

I am trying to calculate the number of working days remaining in a project plan, but if the end date is in the past it is showing negative numbers. How do I change this to show a 0 instead of the negative number if the task is complete? This is the current formula I am using: =IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row))

• ✭✭✭✭✭✭
Options

Try this:

=IFERROR(IF(NETWORKDAYS(TODAY(), [End Date]@row) >= 0, NETWORKDAYS(TODAY(), [End Date]@row), 0), "")

If the networkdays is 0 or greater, give me the networkdays; otherwise (i.e. networkdays < 0), give me 0.

(The IFERROR suppresses error messages on rows where you don't have an End Date.)

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭
Options

=IF(NETWORKDAYS(TODAY(), [End Date]@row) < 0, 0, NETWORKDAYS(TODAY(), [End Date]@row))

• ✭✭✭✭✭✭
Options

Try this:

=IFERROR(IF(NETWORKDAYS(TODAY(), [End Date]@row) >= 0, NETWORKDAYS(TODAY(), [End Date]@row), 0), "")

If the networkdays is 0 or greater, give me the networkdays; otherwise (i.e. networkdays < 0), give me 0.

(The IFERROR suppresses error messages on rows where you don't have an End Date.)

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• Options

Thank you so much! This worked!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!