Show Zeros

  • Thread starter Thread starter Frank
  • Start date Start date
F

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
 
Try =MAX(0,Your_Formula) eg:-

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