Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copy down formula (2003)

    I have a spreadsheet that I have some formulas and I want to copy them down even though the other fields aren't filled in. I want the formula copied down but I don't want anything to appear until the correct fields are filled in. These are the formulas:
    =IF(E8<>"Done",NETWORKDAYS(TODAY(),D8),"")
    =IF(E8<>"Done",NETWORKDAYS(TODAY(),D8,MyHolidays), "")

    I guess I want to add something so that if the fields are empty then where the formula is copied to be blank also. I want to copy the formulas down as far as they can go so that the person using the spreadsheet doesn't have to keep copying down the formula.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Copy down formula (2003)

    Try

    =IF(AND(NOT(ISBLANK(D8)),E8<>"Done"),NETWORKDAYS(T ODAY(),D8),"")

    or perhaps

    =IF(AND(NOT(ISBLANK(D8)),NOT(ISBLANK(E8)),E8<>"Don e"),NETWORKDAYS(TODAY(),D8),"")

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copy down formula (2003)

    Thanks Hans - that worked.

Posting Permissions

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