Results 1 to 3 of 3

Thread: Need help in formula

  1. #1

    Need help in formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have 4 different dates in 4 cells and I want to apply IF condition with networkdays that if 1st cell is empty takes the second and calculates networkdays if second and also empty calculates with third one. I apply the formula =IF(AW5="",NETWORKDAYS(AT5,AV5),IF(AV5="",NETWORKDAYS(AT5,AU5),NETWORKDAYS(AT5,AU5))) but the issue is that its giving me negative days because 1st 2 cells are empty and its not fulfilling the condition. Please help

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,372
    Articles
    0
    Perhaps...

    =IF(AND(AW5="",AV5=""),NETWORKDAYS(AT5,AU5),NETWORKDAYS(AT5,AV5))


  3. #3
    Thanks alot

Posting Permissions

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