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

Kristin Fortner

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

Jeff Reisman

@Kristin Fortner

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.)

Christian Graf

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

Jeff Reisman

@Kristin Fortner

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.)

Kristin Fortner

Thank you so much! This worked!