Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    May 2002
    Location
    California, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Networkdays Formula Help (2000 sp3)

    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

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Networkdays Formula Help (2000 sp3)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •