How to make a number less than 0 show up as 0
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))
Help Article Resources
Check out the Formula Handbook template!