Number lower than 0 to show 0 using IF

Frederik Soerensen · 03/30/21

I have a column called "Days worked", which I get using: =NETWORKDAY([Start date]143; TODAY()).

I use this for all tasks, including future. Therefore it shows a negative number when it is a future project that has not started yet.

I want it instead to say 0.

I tried with: =NETWORKDAY([Start date]143; TODAY()), IF([Days worked]143<0,"0"

This does not work. Does anyone know how to do it properly?

Thank you in advance.

Andrée Starå · 03/30/21

Hi @Frederik Soerensen

I hope you're well and safe!

Try something like this.

=IF(NETWORKDAY([Start Date]@row; TODAY()) < 0; 0; NETWORKDAY([Start Date]@row; TODAY()))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 03/30/21

@Frederik Soerensen

Excellent!

You're more than welcome!

I've answered in your other question, but here it is as well.

=IF(NETWORKDAY([Start Date]@row; TODAY()) > Duration@row; 0; IF(NETWORKDAY([Start Date]@row; TODAY()) < 0; 0; NETWORKDAY([Start Date]@row; TODAY())))

Andrée Starå · 03/30/21