Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multiple IF statement (Excel 2003)

    Hello!

    I need some help with an IF statement with multiple variables.

    In cell R21 I need a formula that will calculate the number of networkdays between cell P21 and E21. The variables are:

    If cell E21 is a weekend then the number of networkdays would increase by 1.
    If cell P21 is a weekend and E21 is that same weekend then the number of networkdays would still be 1.
    If cell Q21 is greater than 12:00 PM (.5) then the number of networkdays would decrease by 1
    If cell Q21 is lesser than 12:00 PM then the there would be additional increase or decrease of networkdays.

    I hope that this makes sense. I had a formula but it doesn't seem to give me what I need and I am not sure how to adjust it.

    =IF($G21="",0,IF(WEEKDAY($E21)=7,IF(IF($Q21>0.5,NE TWORKDAYS(P21,E21,Holiday)-1,NETWORKDAYS(P21,E21,Holiday))<=0,1,(IF($Q21>0.5, NETWORKDAYS(P21,E21,Holiday)-1,NETWORKDAYS(P21,E21,Holiday))))+1,IF(IF($Q21>0.5 ,NETWORKDAYS(P21,E21,Holiday)-1,NETWORKDAYS(P21,E21,Holiday))<=0,1,(IF($Q21>0.5, NETWORKDAYS(P21,E21,Holiday)-1,NETWORKDAYS(P21,E21,Holiday))))))

    Thanks,

    Marie
    Attached Files Attached Files

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

    Re: Multiple IF statement (Excel 2003)

    Does this do what you want?

    =IF(G21="",0,NETWORKDAYS(P21,E21,Holiday)+(WEEKDAY (P21,2)>5)-(Q21>0.5))

Posting Permissions

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