Show Zeros

[Frank]

I have the following formula in a cell, however I am
running this for a whole year and the cells in the future
months of the year show a negative number. Where can I
show a zero if the number is a negative.

=IF(($B$31-W1)>=W4,F21,(NETWORKDAYS(W1,$B$31)*F21/W3))

Thanks
Frank

 

[Ken Wright]

Try =MAX(0,Your_Formula) eg:-

=MAX(0,IF(($B$31-W1)>=W4,F21,(NETWORKDAYS(W1,$B$31)*F21/W3)))