Problem with an IF Formula

[miquele506]

I’m trying use and IF formula with networkdays and I want it to stop when a process is filled cancelled or on hold, for some reason it is telling there is a missing parenthesis.

At this point i don’t know what to do:

Any advice will be well received

=IF(T20="Cancelled";NETWORKDAYS(U20;Z20); NETWORKDAYS(U20;B6) IF(T20="Filled";NETWORKDAYS(U20;Z20);NETWORKDAYS(U20;B6)) IF(T20="On Hold";NETWORKDAYS(U20;Z20); NETWORKDAYS(U20;B6))

 

[MarcelBeug]

You have 3 different formulas instead of 1.

Try:

=IF(T20="Cancelled";NETWORKDAYS(U20;Z20);IF(T20="Filled";NETWORKDAYS(U20;Z20);IF(T20="On Hold";NETWORKDAYS(U20;Z20);NETWORKDAYS(U20;B6))))

 

[jtakw]

Hi,

Your formula syntax is incorrect, and if I follow the logic of your formula, it can be shortened to:

=IF(OR(T20={"Cancelled","Filled","On Hold"}),NETWORKDAYS(U20,Z20),NETWORKDAYS(U20,B6))

Change the comma to semicolon ( , to ; ) for your region, or like this:

=IF(OR(T20={"Cancelled";"Filled";"On Hold"});NETWORKDAYS(U20;Z20);NETWORKDAYS(U20;B6))

 

[miquele506]

Hello guys, I am a noob using Excel, but with your help I finally fixed the problem. I really appreciate your help sending the shorten formulas.

 

[miquele506]

Thanks, your formula worked pretty well. You rock in Excel!

 

[miquele506]

Hello jtakw, I really liked the way you made this formula shorter. I end up using this one. thank you so much.

 

[miquele506]

This thread was Resolved.

 

[jtakw]

Hello jtakw, I really liked the way you made this formula shorter. I end up using this one. thank you so much.

You're welcome, welcome to the forum.

 

[MarcelBeug]

Hello jtakw, I really liked the way you made this formula shorter. I end up using this one. thank you so much.

Well, I thought it would be better to understand first to correct the syntax and next to improve the formula.