Networkdays Formula Help (2000 sp3)

[hlstew]

Hi, I am having trouble with my spreadsheet, (see attached). I would like the Totals fields to show either blank or zeros instead of the weird long negatives, when all the cells are not full. Does anyone know how to correct the formula so that it shows correctly. Thanks so much

[sdckapr]

The problem is that col K is zero and when you subtract the large number in col I from zero you get a large neg number. I assume you want to put something else in L when K is negative:

You could add
=if(k2=0,0, Networkdays...etc) to add a zero
or even
=if(k2=0,"", Networkdays...etc) to make it appear empty
or even
=if(k2=0,"No Seal Date", Networkdays...etc) to display a message

You might also want to change the formula in N which needs this value:
=if(k2=0,"No Seal Date",H2+J2+L2)

Steve