How do I combine a VLOOKUP formula and a NETWORKDAYS formula?

[Tracy]

If cell G3 equals "Defer to Network" then I want cell J3 to equal "N/A". If
cell G3 equals "MTF Accept" then I want cell J3 to use a NETWORKDAYS formula
to calculate the difference in days. How do I combine the two formulas?
Thanks.

 

[Fred Smith]

In J3, you want:

=if(g3="Defer to Network","N/A",if(g3="MTF Accept",networkdays(...),"neither
defer nor accept"))

Regards,
Fred.

 

[Tracy]

Wonderful!!! Thank you.

In J3, you want:

=if(g3="Defer to Network","N/A",if(g3="MTF Accept",networkdays(...),"neither
defer nor accept"))

Regards,
Fred.