# Thread: Multiple IF statement (Excel 2003)

1. ## 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

2. ## 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
•